Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
Can you help with my measure?
Renewals rate = [Renewals]/[Settlements]
I had to turn off interaction to Settlements and my calculation is not accurate.
Thanks
Andrej
Solved! Go to Solution.
Hi @AndrejZitnay,
Based on my understanding, the Settlements won't be filtered by the slicer, and you want to return values filtered [Renewals] divided by not filtered [Settlements], right?
In your scenario, please modify the measure with ALL() function like below:
Renewals rate = [Renewals]/CALCULATE([Settlements],ALL(<your table name>))
Best Regards,
QiuyunYu
Hello @v-qiuyu-msft
I have now solution
Rate =
[Measure Renewals related]
/ CALCULATE ( [Settlements], ALL ( 'tab B'[DateColumn] ) )
Thank you very much anyway for your time.
Kind regards.
Andrej
Hi @AndrejZitnay,
Based on my understanding, the Settlements won't be filtered by the slicer, and you want to return values filtered [Renewals] divided by not filtered [Settlements], right?
In your scenario, please modify the measure with ALL() function like below:
Renewals rate = [Renewals]/CALCULATE([Settlements],ALL(<your table name>))
Best Regards,
QiuyunYu
Hello @v-qiuyu-msft QiuyunYu,
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 help.
Kind regards.
Andrej
Hello @v-qiuyu-msft
I have now solution
Rate =
[Measure Renewals related]
/ CALCULATE ( [Settlements], ALL ( 'tab B'[DateColumn] ) )
Thank you very much anyway for your time.
Kind regards.
Andrej
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |