Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to 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.
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.
Thank you so much, I can see now hoy obvious it was but I was unable to get it myself. Much appreciate!
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
66 |
User | Count |
---|---|
115 | |
103 | |
93 | |
64 | |
61 |