topic Count with multiple criteria in DAX Commands and Tips

Count with multiple criteria

dofrancis3 — Thu, 01 Feb 2024 04:03:25 GMT

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.

dofrancis3 — Thu, 01 Feb 2024 04:07:32 GMT

This is the colomn

I would like to have 8

i don't like Count fountion

wdx223_Daniel — Thu, 01 Feb 2024 04:08:49 GMT

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

govindarajan_d — Thu, 01 Feb 2024 05:16:23 GMT

Please try this:

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

dofrancis3 — Thu, 01 Feb 2024 10:25:27 GMT

Thank you so mutch Daniel it work