Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |