Forum Discussion
Calculation issue due to interaction
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
Hello v-ljerr-msft
Thank you for your respond.
I will try to make it more clear.
I have two date slicer on my measure.
1st Date of renewals which have all active interaction
2nd Retention Renwals which have one blocekd interaction as settlements shouldn't change.
Both Measures for Renewals & Settlements comes from excel tab A (symple count if formula)
Slicer Date of Renewals is Date table for excel tab A & excel tab B
Slicer Retention Periods is date from excel tab B
Many thanks in advance for your kind help.
Kind regards.
Andrej
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
Hello v-ljerr-msft
OMG!!!
You are star.
Now my measure works perfectly!!!
Thank you very much.
Kind regards.
Andrej