Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
How can ALLSELECTED work when I filter a value included in one of the measures required to calculate the percentage?
Number of Visits
# Visits = CALCULATE(SUM(Main[VALUE]),ALL(Main[OrderCode]), FILTER(ALLSELECTED(Main),Main[OrderCode]= 1))
Number of Incomplete Visits
# Visits Incomplete = CALCULATE(SUM(Main[VALUE]), ALL(Main[OrderCode]), FILTER(ALLSELECTED(Main),Main[OrderCode]= 2))
Measure
Measure = IF(MIN(Main[OrderCode]) = 3 , [# Visits Incomplete]/[# Visits], BLANK())
Thank you
When modifying two measures as below, I can calculate the percentage.
# Visits = CALCULATE(SUM(Main[VALUE]),FILTER(ALL(Main),Main[OrderCode]= 1))
# Visits Incomplete = CALCULATE(SUM(Main[VALUE]), FILTER(ALL(Main),Main[OrderCode]= 2))
Best Regards
Maggie
Using ALL would aggregate the numbers in the roll up level. You can't see that in the sample above, but if you add dates (which is what I have in my real report), you'll be able to see the issue. Is there another option?
Could you show me some example dataset which will effect the result you want for better analysis?
Best Regards
Maggie
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
86 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |