Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I have an expression that works perfectly until I apply a filter:
Solved! Go to Solution.
Hi,
Does this measure work?
Plan_Rate = divide((sum(Tiering[Retained_AP_ZRC])-sum(Tiering[Retained_AP])),sum(Tiering[Retained_AP]))
Format this measure as a %.
Hi,
Does this measure work?
Plan_Rate = divide((sum(Tiering[Retained_AP_ZRC])-sum(Tiering[Retained_AP])),sum(Tiering[Retained_AP]))
Format this measure as a %.
Yes, that works perfectly. Thank you very much for your help!
You are welcome.
If You can create two different views?!
Proud to be a Super User!
It's a report, the way it is currently setup the users choose filters. Someone brought to my attention that when they apply a date filter and then scroll down they can see entries that should not reflect, although the totals are fine.
My head says there must be a way within Power BI to apply a percentage filter correctly. The method I used is one I use in Excel and R, but I appreciate that Power BI uses Dax.
But yes, creating two pivot tables to correct something that should not show on the pivot table in the first place won't do in this example.
Try using ISFILTERED
IF(ISFILTERED(Filter),Plan_Rate wihtout "-1", Plan_Rate with "-1")
it should give you the right view.
Proud to be a Super User!
Hi @VijayP , Thank you for your suggestion. Am looking up your syntax suggestion now, it's new to me. From what I can gather if a filter is applied then show plan rate without -1, but if a filter is not applied then show the -1.
Only problem I have is that users will want to be able to view the same pivot table in a filtered and unfiltered form.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
153 | |
125 | |
114 | |
111 | |
95 |