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

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
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

Hello v-ljerr-msft

 

OMG!!!

You are star.

 

Now my measure works perfectly!!!

 

Thank you very much.

 

Kind regards.

 

Andrej