Creating a measure that counts values from other measures

[jagostinhoCT]

I have created measures to grade different aspects of my data (highlighted in yellow in the measures list)

Is there a way that I can create another measure that it looks at all the values from the other measures?

For instance, from the example, let's say that

Green = 0

Amber = 1

Red = 3

And I I want it so that if

the sum of all different measures is < 7 the General Grading is "Green";

If  is 7 < x < 14 is "Amber";

if it is > 14 is "Red".

I plan to develop additional grading aspects. What is the best way of doing it so that I can easily update the General Grading to acommodate these additional gradings?

Thank you

J

[v-cherch-msft · Accepted solution]

Hi @jagostinhoCT 

You may create a measure like below and then use conditional formatting.

Measure =
IF (
    [Measure1] + [Measure2] + [Measure3] < 7,
    IF ( [Measure1] + [Measure2] + [Measure3] > 14, 3, 2 )
)

Regards,