Forum Discussion

krp1317's avatar
krp1317
New Member
8 years ago

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 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!

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI krp1317,

     

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

     

    Regards,

    Xiaoxin Sheng

  • SoniaRadaelli's avatar
    SoniaRadaelli
    Regular Visitor
    4 years ago

    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