Forum Discussion

1 Reply

  • FrankAT's avatar
    FrankAT
    Community Champion

    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)