Help to calculate a percentage

[DRJ1994]

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. 

[rajulshah]

Hello @DRJ1994 ,

Would you be able to share what is in the measures?

[DRJ1994]

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. 

[v-easonf-msft · Accepted 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