Forum Discussion

dofrancis3's avatar
dofrancis3
Resolver 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),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's avatar
    wdx223_Daniel
    2 years ago

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

4 Replies

  • dofrancis3's avatar
    dofrancis3
    Resolver 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
      Super User
      2 years ago

      Please try this:

      PassFailCount =
CALCULATE (
    COUNTROWS ( IMrepository ),
    KEEPFILTERS ( IMrepository[Dist_targ_SIA] IN { "Pass", "Fail" } )
)
  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    2 years ago

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