Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
NbrDistr = CALCULATE(COUNTROWS(IMrepository),IMrepository[Dist_targ_SIA]= "Pass"||IMrepository[Dist_targ_SIA]= "Fail")
NbrDistr = CALCULATE(COUNTROWS(IMrepository),IMrepository[Dist_targ_SIA]= "Pass"||IMrepository[Dist_targ_SIA]= "Fail")
Thank you so mutch Daniel it work
This is the colomn
I would like to have 8
i don't like Count fountion
Please try this:
PassFailCount =
CALCULATE (
COUNTROWS ( IMrepository ),
KEEPFILTERS ( IMrepository[Dist_targ_SIA] IN { "Pass", "Fail" } )
)
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |