Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |