Forum Discussion
Conditional Formatting with Calculation Groups and Measure Table
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!!
2 Replies
- DQuiggAdvocate III
Thank you amitchandak !!
The first one looks reasonably close. I will need to kind of walk through it piece by piece.