Count with multiple criteria

[dofrancis3]

Hi Guys!

Some one can help me please!

I would like to count the number of "Pass" and "Fail" how can i dot it please below is my Dax-mesure:

NbrDistr = CALCULATE(COUNTROWS(IMrepository),IMrepository[Dist_targ_SIA]= "Pass")

i would like to also count "Fail" in the criteria

how can i do it?

Thank for your assistance.

[wdx223_Daniel · Accepted solution]

NbrDistr = CALCULATE(COUNTROWS(IMrepository),IMrepository[Dist_targ_SIA]= "Pass"||IMrepository[Dist_targ_SIA]= "Fail")

[dofrancis3]

Thank you so mutch Daniel it work

[dofrancis3]

This is the colomn

I would like to have 8 

i don't like Count fountion

[govindarajan_d]

Please try this:

PassFailCount =
CALCULATE (
    COUNTROWS ( IMrepository ),
    KEEPFILTERS ( IMrepository[Dist_targ_SIA] IN { "Pass", "Fail" } )
)