Forum Discussion

franorio's avatar
franorio
Helper III
9 years ago

Measure for different measures?

Hello everybody, got 5 different measures in 5 different tables.  Table1, measure A Table 2, measure B   Table 3, measure C Table 4, measure D Table 5, measure E   all measures return a value...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Give this a crack

 

Measure = 
VAR MyTotal = [MeasureA] + [MeasureB] + [MeasureC] + [MeasureD] + [MeasureE]
RETURN SWITCH(
                TRUE() ,
                MyTotal > .9 , "Green" ,
                MyTotal > .8 , "Orange" ,
                "Red")
franorio's avatar
franorio
Helper III
9 years ago

Thanks Phil!
The formula works and  returns ¨Green¨, ¨Yellow¨ and ¨Red¨. But it does not work for me, it calculates the var for the sum of all measures.
I need to consider all of them in the same formula, but to return the color for each measure by it self if it applys, for example measure C if 90% = green and if measure b 82% = yellow  & also if measure B = .....

by the moment it works as total of all.. var = measure a + measure b + measure c + measure d = 90% = green

is there a way to separe the total of each measure by it self?

 

Thanks a lot

 

Regards