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.
Hello, I have a boolean that looks at 2 conditions to make a decision. Then I have a measure that is supposed to count the number of "Failed" conditions. My count calculation keeps pulling both conditions instead of just one "fail". I have included both of my calculations as well as a screen shot of my results. What I want is for my "Count of Fail" to only count the number "Fail" words, not the number of failed conditions.
Here is what I want from the following DAX code (I only want the document to fail 1 time. Even if both conditions are met):
CONDITION: IF condition A is met then fail
IF condition B is met then fail
CODE: Pass/Fail = IF(OR(Rejected[Action] = "REJECTED", Rejected[Status Code] = "BACKWARD"),"Fail", "Pass")
Here is my Count of Fail code:
Document | Rejected | Backward | Pass/Fail | Count of Fail |
abc | 1 | 1 | Fail | 2 |
ded | 1 | 0 | Fail | 1 |
iek | 0 | 1 | Fail | 1 |
oow | 1 | 1 | Fail | 2 |
ytr | 0 | 0 | Pass | 0 |
Solved! Go to Solution.
I ended up changing my counting formula. I counted the number of documents that had a status of "Fail".
I ended up changing my counting formula. I counted the number of documents that had a status of "Fail".
Just use MAX instead of COUNT aggregation.
Thank you. I forgot about the MAX and I will use that on another one of my issues but, that only returns the text "Fail". My result with using MAX is: Count of Fail = "Fail" I need a count of how many documents failed.
Oh, I was referring to MAX of your two numeric columns (1's and 0's). You can use MC Aggregations for that.
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |