Forum Discussion

prashantg364's avatar
prashantg364
Icon for Helper II rankHelper II
3 years ago
Solved

DAX

Below is my dataset Product Category A Category B Category C Category D Category E Category F Category G Category H Java Pass Pass Fail Fail Fail Pass Pass Pass Honda Fail ...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi prashantg364 

    Please refer to attached sample file with the proposed solution

    Measure = 
IF ( 
    ISINSCOPE ( 'Table'[Category] ),
    SELECTEDVALUE ( 'Table'[Status] ),
    COUNTROWS ( 
        FILTER ( 
            'Table',
            'Table'[Status] = "Pass"
        )
    ) + 0
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi prashantg364 

Please refer to attached sample file with the proposed solution

Measure = 
IF ( 
    ISINSCOPE ( 'Table'[Category] ),
    SELECTEDVALUE ( 'Table'[Status] ),
    COUNTROWS ( 
        FILTER ( 
            'Table',
            'Table'[Status] = "Pass"
        )
    ) + 0
)