Forum Discussion

wenchi's avatar
wenchi
Icon for Helper I rankHelper I
5 years ago

dynamic title from calculation group selection

my report connect to AS model using live connection. The AS model contains few calculation groups including time intelligence and measure metric, such as volume, store count, etc. They all work as expected. I am trying to create a dynamic chart tiltle based on the item the user pick from calculation group. For example, if the user choose volume, the title will show "YoY Volume Comparsion" or "YoY Store Count Comparison" if the user choose store count from calculation group. I can't find a way to get the the selected item from calculation group. I've tried selectedvalue or isfilter dax, and none of them work. Any one get this to work ?

Another related question to calculation group is how to create a measure that can ignore the calculation group? I use ALL in my dax code, and it does not work either. Sometimes I need to display data in a table and not all measures in this table that i want to work with calculation group and I can't find a way to solve it either.

Any helps is appreciated.

 

thanks,

Wenchi Wang

3 Replies