Forum Discussion

prashantg364's avatar
prashantg364
Helper II
3 years ago
Solved

DAX

Below is my dataset

ProductCategory ACategory BCategory CCategory DCategory ECategory FCategory GCategory H
JavaPassPassFailFailFailPassPassPass
HondaFailFailFailPassPassFailFailFail
AmazePassPassPassPassPassPassPassPass
FiatFailFailFailFailFailFailFailFail
DunoPassPassPassPassPassFailFailFail
SedanPassFailPassFailFailFailFailFail

 

I want to add a column at the end to count the total number of pass

ProductCategory ACategory BCategory CCategory DCategory ECategory FCategory GCategory HCount of Pass
JavaPassPassFailFailFailPassPassPass5
HondaFailFailFailPassPassFailFailFail2
AmazePassPassPassPassPassPassPassPass8
FiatFailFailFailFailFailFailFailFail0
DunoPassPassPassPassPassFailFailFail5
SedanPassFailPassFailFailFailFailFail2



  • 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
)

1 Reply

  • tamerj1's avatar
    tamerj1
    Community 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
)