Percentage ignoring a category

[mb0307]

Hi all,

I have a table like this4

I would like to calculate Percentage but ignoring if Range = 0.  Correct result showing in the table column Percentage.

2nd question,  I want to then use % in different cards like this

How can I achieve this please?

[VahidDM · Accepted solution]

Hi @mb0307 

Please download the attached file to find the measure and solutions.

Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[mb0307]

thanks @VahidDM