Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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"))
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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"))