Combine Multiple "OR" Statements into one

[moshiera]

See screen shot below to see and example of what i'm looking for...

I trying to get the over all complaince for a site.  If you look across each site if all percentages are above 95% that site is "fully compliant" (SEE NC), However if any of the different percenetages falls between 90%-95% the site falls to a "partial compliance" (SEE NY), and if any of the percentages fall below 90% then the site is "non compliant"(SEE RI).  I can get them to work separately using the following different measures however not sure how to combine them into one measure. 

Concern Indicator = IF([HP%]>=.95,IF([DP%]>=.95, IF([EN%]>=.95,IF([CN%]>=.95,IF([SN%]>=.95,IF([LM%]>=.95,"Fully Compliant"))))))

Concern Indicator = IF([HP%]<.90 || [DP%]<.90 || [EN%]<.90 || [CN%]<.90 || [SN%]<.90,|| [LM%],<.90,"Non Compliant") 

Concern Indicator = IF([HP%]<.9499 || [DP%]<.9499 || [EN%]<.9499 || [CN%]<.9499 || [SN%]<.9499,|| [LM%]<.90,"Partially Compliant") 

[v-xuding-msft · Accepted solution]

Hi @moshiera ,

I created a measure using the function of SWITCH that may help you.

Measure = SWITCH(TRUE(),
MAX('Table'[CN%] )>=0.95 && MAX('Table'[DP%])>=0.95 && MAX('Table'[EN%])>=0.95 && MAX('Table'[HP%])>=0.95 && MAX('Table'[LM%])>=0.95 && MAX('Table'[SN%])>=0.95, "fully compliant", 
MAX('Table'[CN%] )<0.9 || MAX('Table'[DP%])<0.9 || MAX('Table'[EN%])<0.9 || MAX('Table'[HP%])<0.9 || MAX('Table'[LM%])<0.9 || MAX('Table'[SN%])<0.9,"non compliant",
"partial compliance"
)

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.