Bucket location based on two data points

[moslefn]

So far I have two DAX MEASURES that result in a text bucket.

9 Quad SC = IF('SC- A'[SC%]>.20,"Top",IF('SC- A'[SC%]>.10,"Mid","Low"))

9 Quad Util = if(AVERAGE('Util- A'[Utilization])>.95,"Top",IF(AVERAGE('Util- A'[Utilization])>.80,"Mid","Low"))

Based on the combo of these outcomes, I want to classify my locations as follows:

9 Categories for centers

• Top Performers (above 95% utilization/above 20% SC)
• Moderate Cost Drivers (above 95% utilization/10-20% SC)
• Moderate Enrollment Needs (80-95% utilization/above 20% SC)
• Moderate Performers (80-95% utilization/10-20% SC)
• High Enrollment Needs (below 80% utilization/above 20% SC)
• High Cost Drivers (above 95% utilization/below 10% SC)
• Moderate Focus - Enrollment (below 80% utilization/10-20% SC)
• Moderate Focus - Cost Drivers (80-95% utilization/below 10% SC)
• High Focus School (below 80%/below 10% SC)

But, my IF/AND formauls will not reference 9 Quad SC/Util measures...HELP!

Open to any help to achieve the final outcome. 

[vanessafvg · Accepted solution]

if you are creating a measure to get these measures, i would definitely suggest you first look using switch statements as they are easier to read with multiple conditions that if statements if you aren't aware of them already.

Secondly if you are creating a measure you do need to first aggregate (either sum, count, min, max) the results of your if statement before you can reference it in a measure.  Hope that makes sense.