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...
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!