I need your guidance on using worksheet as filter. This is unique situation when I am not able to use worksheet as filter. The sheet which I am trying to use as filter uses Measure Values & Measures Name as mentioned in fig1. Race indicators (AIAN ind, Asian Ind etc.) are columns in my data source and any member can fall under multiple race. I am trying to filter base data (Member count ) as user select race indicator but unfortunately I am not able to do by using dashboard action or worksheet (Use as filter) option. Guess, this is because of indicators are used as measure.
I will really appreciate your input on this issue. Just wondering if I can implement this using different approach.