Forum Discussion
Wrong Absolut valute
Hi
I have created a measure which is:
Forecast Error = (SUMX(Salesdata_1; Salesdata_1[Salg_L]) - SUMX(Forecast_Data;Forecast_Data[Forecast_L]))
The total of this is -15873,94
I want to make another measure which takes the absolute value for each row, and summarizes it. The value of this should be 58 771. Have tried some measure already, and I either get an error message, 15873,94 (absolut value of total forecast error) or 270105,99 (total sales in may)
The measure is in the Salesdata table
Regards
1 Reply
- parry2k
Super User
Haroon95 Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
