Forum Discussion
Solved
Incorrect Measure Total
Hello, I'm having a problem calculating the total absolute error by category. 'Table1' Data: I created a measure to calculate the median value: MEDIAN_VALUE = CALCULATE ( MEDIAN('T...
It's because DAX doesn't add your rows above, instead it calulates the expression on the totals. Hence, you get 8,087.5. You need to iterate over your rows instead of looking at the totals.
Absolute Error 2 = SUMX(VALUES(Table1[PN]), [Absolute Error])
This article might be helpful for you in the future!
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
It's because DAX doesn't add your rows above, instead it calulates the expression on the totals. Hence, you get 8,087.5. You need to iterate over your rows instead of looking at the totals.
Absolute Error 2 = SUMX(VALUES(Table1[PN]), [Absolute Error])
This article might be helpful for you in the future!
https://www.sqlbi.com/articles/why-power-bi-totals-might-seem-inaccurate/
Syk thank you, that worked!