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%

 

I have there some interaction conditions and calculation is

picking up 827 / 218 is 26.36%

 

I have two date filters on numerator and denominator and in one occasion is interaction blocked as it must be that way.

 

Is there measurement for actual % so measurement will ignore interaction?

 

Thank you.

 

Kind regards.

 

Andrej

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