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

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?

      • AndrejZitnay's avatar
        AndrejZitnay
        Post Patron
        9 years ago

        Hello Siva,

         

        It is hard to give you sample data but I get both figures as measurment with counting rows in excel.

        I am sure that problem is with Edit Interaction.

         

        You can see on my first picutre that it is off on first screenshot.

         

        I need jsut get right calculation.

        My current formula is taking into considiration interaction betwen slicers.

         

        Andrej