Conditional Formatting with Calculation Groups and Measure Table

[DQuigg]

Hi All,

I am new to calculation groups so still learning and hoping I can get some help.

I have a measure table that simply swaps out measures using SWITCH statements to other explicit measures based on the table selection. I have over 150 measures in this table and I want the user to be able to select them dynamically. So far so good. 

The problem is that some of them should be formatted as whole numbers and some as percentages. So it seems like a natural job for calculation groups except the only examples I have seen for calculation groups are using explicit measures. Here, I need to essentially qualify the result based on the selection in the measure table. I tried using ISSELECTEDMEASURE but the name used is the master KPI measure. Seems very basic yet so elusive. How can I use the measure as selected from my table and then format it using calculation groups?

Thanks!!

[DQuigg]

Thank you @amitchandak !!

The first one looks reasonably close. I will need to kind of walk through it piece by piece. 

[amitchandak · Accepted solution]

@DQuigg , refer if these can help

https://www.esbrina-ba.com/calculation-groups-and-conditional-formatting-yes-its-possible/

https://blog.enterprisedna.co/conditional-formatting-in-calculation-groups-power-bi/

https://www.youtube.com/watch?v=TpD57zS2sQU