Divide values from same column

[Anonymous]

Hello there,

I have this table:

Name	Status	Date
Jack	KO	02-02-2022
Mary	KO	02-02-2022
Jack	KO	02-02-2022
Danny	OK	02-03-2022
Mary	OK	02-03-2022
Danny	KO	02-03-2022

And I'm trying to make a table visualization similar to this:

Name	OK	KO	Total	% KO
Jack	0	2	2	100%
Mary	1	1	2	50%
Danny	1	1	2	50%

The problem is related to that % last column. Since the KO and OK values are within the same column, I don't know how to make the percentage of KO's out of the total count and add it to the visual. I'm sure there has to be a measure that can do it, but I can't figure it out. 

Thank you,

[johncolley · Accepted solution]

Hi @Anonymous ,

You can achieve the end product table you are after with the following measures:

KO Count = CALCULATE(COUNT(Ko[Status]), Ko[Status] = "KO") + 0

OK Count = CALCULATE(COUNT(Ko[Status]), Ko[Status] = "OK") + 0

Total Count = Ko[KO Count] + Ko[OK Count]

Pct = Ko[KO Count]/ [Total Count] 

You'll need to format PCT as a %

Hope this helps.

[Anonymous]

Thank you so much, I can see now hoy obvious it was but I was unable to get it myself. Much appreciate!