Forum Discussion

binayjethwa's avatar
binayjethwa
Icon for Helper V rankHelper V
3 years ago

How to Refer a Calculated column in A Measure

Hi ,   I have the following requirement , where i need to change font color based on conditions. I have Performance as my calculated column.   I am not getting actual result based on below measu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago
Overall_Color_BLs =
VAR Overall= SUM(All_Bls_Fct[OverallPerformance_New])

 

return
SWITCH(
    TRUE(),
    overall>=0.95,"#F34E4E",
    overall>=0.85 && [overall] <0.95,"#E7A76C",
    [overall]<0.85,"#5BA35F")

Give this a go 🙂 
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    If not, make sure that the column "OverallPerformance_New" is of numeric data type and contains valid numbers.