Forum Discussion

Haroon95's avatar
Haroon95
Regular Visitor
7 years ago

Absolut value pr row

Hi   Is it any function which allows you to calculate the absolute value pr row, and then summarize this? Tried the "Absolut" function, but the outcome is not right   Thnx
Need Help
Haroon95's avatar
Haroon95
Regular Visitor
7 years ago

Hi 
tried it now, and this error comes up. Think its because I am trying to calculate abs value of a measure, and not a column. My solution was to extract the measure values to excel, sort the data, and then create a new table with the absolute values.

Do you have a way to calculate total abs value for a measure?

Regards.

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi ,

 

No need to add Max ahead of the measure name and using SUMX:

Measure 3 = SUMX(Table1,ABS([Measure 2]))

Best regards,

Dina Ye