Count of Boolean

[Anonymous]

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:

Count of Fail = CALCULATE(COUNT(Rejected[Pass/Fail]), FILTER(Rejected, Rejected[Pass/Fail] = "Fail"))

And here is the result I am getting. See where it says 2 when both conditions have been met? I only want it to fail one time no matter how many failures there are.

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

[Anonymous · Accepted solution]

I ended up changing my counting formula.  I counted the number of documents that had a status of "Fail".

CALCULATE(DISTINCTCOUNT(Rejected[Change Number]), FILTER(Rejected, Rejected[Pass/Fail] = "Fail"))

[Greg_Deckler]

Just use MAX instead of COUNT aggregation.

[Anonymous]

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.

[Greg_Deckler]

Oh, I was referring to MAX of your two numeric columns (1's and 0's). You can use MC Aggregations for that. 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Multi-Column-Aggregations-MC-Aggregations/m-...