Incorrect Measure Result when Dividing Negative Numbers

[krp1317]

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 Amount])/CALCULATE(SUM('Monthly Churn Budget'[Churn Budget]))

I did essentially the same thing for sales actual vs budget and got correct percentages, but it is not working for churn. As you can see in the photo below the percentages are not correct.

I am fairly new to this but have researched a lot of posts so I really apologize if this has been solved elsewhere.

Thank you!

[SoniaRadaelli]

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

[Anonymous]

HI @krp1317,

It will be help, if you provide more detailed contents and sample data. 

Regards,

Xiaoxin Sheng