Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have this formula which is present in a matrix visualization
M = CALCULATE(SUMX(ProdForecast,abs([TotalActual]-ProdForecast[Forecast])),'M view'[Category]="M")
My headache today is to somehow determine what is the sign of
[TotalActual]-ProdForecast[Forecast]
before the ABS formula is applied.
Example: If TotalActual-Forecast is -8 in the matrix I will have 8 but somehow to determine the initial sign and put it as conditional formating or something in a matrix.
Solved! Go to Solution.
https://docs.microsoft.com/en-us/dax/sign-function-dax
M =
VAR __Sign = SIGN(ProdForecast[TotalActual]-ProdForecast[Forecast])
RETURN
CALCULATE(SUMX(ProdForecast,abs([TotalActual]-ProdForecast[Forecast])),'M view'[Category]="M")
https://docs.microsoft.com/en-us/dax/sign-function-dax
M =
VAR __Sign = SIGN(ProdForecast[TotalActual]-ProdForecast[Forecast])
RETURN
CALCULATE(SUMX(ProdForecast,abs([TotalActual]-ProdForecast[Forecast])),'M view'[Category]="M")
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |