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

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
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

Thank you so mutch Daniel it work