Formula Question

[KhrystinaM]

Hello, I am hoping someone can help me create a formula based off of multiple measures. 

Current Measures

• "Met" = CALCULATE(COUNTROWS('Status Board'),'Status Board'[Met / Not_x002]="Met")

• "Not Met" = CALCULATE(COUNTROWS('Status Board'),'Status Board'[Met / Not_x002]="Not Met")

• Met/NotMetX = ["Met"]+["Not Met"]

• MetX = SUMX('Status Board','Status Board'[Met Count])

• NotMetX = SUMX('Status Board','Status Board'[Not Met Count])

• Count% = DIVIDE([MetX],[MetXNotMetX],0)

I have a table field for exceptions. I need to add to my "Not Met" and NotMetX formula to not count if Exception Granted = TRUE

Is this possible? Thank you!! 

[KhrystinaM]

This worked, thank you so much!! 

[sayaliredij · Accepted solution]

HI @KhrystinaM 

For Not Met

you can add "and" condition and that should be good 

Measure = CALCULATE(COUNTROWS('Status Board'),AND('Status Board'[Met / Not_x002]="Not Met", Status Board'[Exception Granted]<>"TRUE" ))

for NotMetX

• NotMetX = calculate ( SUMX('Status Board','Status Board'[Not Met Count]),Status Board'[Exception Granted]<>"TRUE" ))

Please try these formule and check if its working 

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!!