Forum Discussion
binayjethwa
Helper V
Helper VHow 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...
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")
Sorr, try this instead! added some extra brackets in the last one.
If it works let me know and accept as solution if you'd be so kind!
Good luck! 🙂