Forum Discussion
Count of Boolean
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 condi...
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
Community Champion
Community ChampionJust 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.
- 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.