Forum Discussion
Divide values from same column
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,
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.
2 Replies
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.