New Measure from same column

[FrankAT]

Hi @kjbecker ,

with my sample data I use the following measures to get the expected result:

Count Status Failed = CALCULATE(COUNTROWS('Table'), 'Table'[Status] = "Failed")

Count Status Passed = CALCULATE(COUNTROWS('Table'), 'Table'[Status] = "Passed")

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)