Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |