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.
Hi all,
I hope somebody is able to assist with my query. I am not 100% sure what I am trying to do is actually possible.
I would like to create a percentage of an overall value.
The 170 on the left is the maximum number. What I would like to achieve is when I click on the slicer at the top that it generates the % for each team.
The card with the percentage on should in my opinion be 100% when the slicer is not selected, however it is showing as 0.00%. I have included the DAX I am trying to use at the top of the screenshot.
Any assistance or advice would be appreciated.
Thank you,
DRJ.
Solved! Go to Solution.
Hi, @DRJ1994
If you want the card to be 100% when the slicer is not selected, you can try to use the function ISFILTERED to get the state of the slicer.
Please add another measure like:
New Percentage =
IF ( ISFILTERED ( 'Slicer'[field] ), [percentage of cases open], 1 )
Apply it to the card visual and display it in % format.
Best Regards,
Community Support Team _ Eason
Hi @rajulshah
The 2 measures are identical really. They are both counts of how many rows are in the 'open case' part of my source data. I just assumed if you divide one by the other it would give me 100%, and then I can use the slicer to get the individual % for each team.
Hi, @DRJ1994
If you want the card to be 100% when the slicer is not selected, you can try to use the function ISFILTERED to get the state of the slicer.
Please add another measure like:
New Percentage =
IF ( ISFILTERED ( 'Slicer'[field] ), [percentage of cases open], 1 )
Apply it to the card visual and display it in % format.
Best Regards,
Community Support Team _ Eason
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |