Getting two percentages out of a 100

[Anonymous]

Hi there,  have two card visuals that have a measure in each of them.

So both visuals represent the only two answers in a collum which can only be Yes or No. However, the %'s are out of a 100, so if yes is 20% then No should be 80%, however it's 125% for some strange reason. Here are the measure's for both visuals below:

Yes Visual:

A5 Yes % = CALCULATE(COUNT('C4 Data'[A5]), FILTER('C4 Data', 'C4 Data'[A5] = "Yes")) / 100

No Visual:

A5 No % = CALCULATE(COUNT('C4 Data'[A5]), FILTER('C4 Data', 'C4 Data'[A5] = "No")) / 100

Where am I going wrong and how do I fix this? Because if I put this in a pie chart, these are the correct %'s that I get which are not close to the measure values above

[TomasAndersson · Accepted solution]

Right now you are dividing the number of Yes' and No's by 100, but you should divide it by the total count in the column to get a percentage.

Try instead:

A5 Yes % = CALCULATE(COUNT('C4 Data'[A5]), FILTER('C4 Data', 'C4 Data'[A5] = "Yes")) / COUNT('C4 Data'[A5])

Hope it works!

[Anonymous]

Hi @TomasAndersson you're a star, looking at it I can't believe I missed that one, thank you very much!