Apply filter on a Calculated Measure

[vishwanathans]

Hi Team,

I feel this one would be tricky for me, If anyone could help me out with this one would be greatly appreciated.

I would like to add a filter to a calculated measure either by a calculated column or a filter.

Prior month is one set of Measure :

LTM is another set of measure :

I would like to add a filter for 8 set of measure to a stacked bar chart and need to toggle between the filters.

This is how my chart looks like :

I would like have all the set of data in the filter but need that leaverage to toggle between the filter to see the trends.

Thanks in advance.

Srini

[vishwanathans]

@Fowmy  This is funtastic. This is exactly what i needed. Thank you so much for the help. 🙂

[Fowmy · Accepted solution]

@vishwanathans 

You can do it using the disconnected table method:
Please refer to: https://www.youtube.com/watch?v=gEeiqsm7BaY

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn