Forum Discussion

dofrancis3's avatar
dofrancis3
Icon for Resolver I rankResolver I
2 years ago
Solved

Count with multiple criteria

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),IMrepositor...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

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

dofrancis3's avatar
dofrancis3
Icon for Resolver I rankResolver I
2 years ago

This is the colomn

I would like to have 8 

i don't like Count fountion

govindarajan_d's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

Please try this:

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