Forum Discussion
Incorrect Measure Result when Dividing Negative Numbers
Hello, I am getting an incorrect measure result when dividing negative numbers (churn actual vs budget). I used this formula as my measure: % Monthly Churn Budget = SUM('2017 Churn Reasons'[MRC ...
I Have the same problem.
this is the dax I'm usign:
%Vs LY =
VAR __BASELINE_VALUE = abs(CALCULATE([SALES YTD], 'sales_totale'[FY] IN { "FY2020" }))
VAR __MEASURE_VALUE = [SALES YTD]
RETURN
IF(NOT ISBLANK(__MEASURE_VALUE),(DIVIDE(__MEASURE_VALUE,__BASELINE_VALUE)))
I have this values:
FY2020 sales = -600
FY2021 sales = 21480
dax result = 3578.3% that is 21480/600 and not 21480/ (-600)
thanks