Power Pivot Measure - converting Negative % to Positive

[Frank J]

I'm trying to convert negative numbers in a measure so that all numbers are positive. DAX keeps telling me there's errors, I've tried many different tweaks to the formula below but nothing is working.

What am I doing wrong? Here's the formula I'm trying to use and below is a thumbnail of the measure.


IF(DIVIDE(SUM(Combined[Promos Issued]),(SUM(Combined[Player Win/Loss])))<0,)

DIVIDE(SUM(Combined[Promos Issued]),(SUM(Combined[Player Win/Loss])))*-1,

DIVIDE(SUM(Combined[Promos Issued]),(SUM(Combined[Player Win/Loss])))

 

[arthurbr]

Hi,
I know nothing about DAX . Perhaps it has the equivalent of the XL ABS() function ?

 

[GraH]

I think you have a comma wrong in your if statement.

 ≤0,)

≤0, ... )

But why so difficult?
Indeed ABS() function exists in DAX. https://www.google.com/url?sa=t&source=web&rct=j&url=https://docs.microsoft.com/en-us/dax/abs-function-dax#:~:text=The%20absolute%20value%20of%20a%20number%20is%20a%20decimal%20number,that%20require%20a%20positive%20number.&ved=2ahUKEwjo9qGvndD3AhXwsaQKHQghDE0QFnoECBEQBQ&usg=AOvVaw1gwFvHj-JsZHnGn9Lm8PtX