Forum Discussion

AndrejZitnay's avatar
AndrejZitnay
Post Patron
9 years ago
Solved

Calculation issue due to interaction

  Hello Power BI experts.   I have little issue with one measurement.   Rate = [Measure Renewals related]/[Settlements]   Is saying that 1624 / 218 is 26.36% It should be actually 13.42%   ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi AndrejZitnay,

     

    Thanks for the detailed explanation. Now I understand it totally. And I believe it you can use ALL or ALLExcept function to get the expected result in this scenario. However, without the sample data for testing, it's hard to provide a tested and correct formula for you. So could you try the formula below to see if it works? :smileyhappy:

    Rate =
[Measure Renewals related]
    / CALCULATE ( [Settlements], ALL ( 'tab B'[DateColumn] ) )

    Regards

SivaMani's avatar
SivaMani
Resident Rockstar
9 years ago

HI AndrejZitnay,

 

What is your requirement?

 

It would be helpful if you attach snap shots

 

Regards,

Siva

AndrejZitnay's avatar
AndrejZitnay
Post Patron
9 years ago

Here it is. I need to get 13.42% out of measurment between Related Renewals & Settlements

 

 

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    9 years ago

    How did you calculate Retention Rate?

     

    I mean the formula if you have used DAX

     

    • AndrejZitnay's avatar
      AndrejZitnay
      Post Patron
      9 years ago

      Rate = [Measure Renewals related]/[Settlements]

      • SivaMani's avatar
        SivaMani
        Resident Rockstar
        9 years ago

        I got it.

         

        Will you be able to share your sample pbix or sample data?