Forum Discussion
Use Measure as a filter
Hi
I have a number of visuals where the list of filtered values is quick long. Rather than having to select the filter on each value, can I create a "static" measure which when applied as a filter applies the filter I need, then if/when I need to change filters I just modify the measure?
Hope that makes sense!
Regards
Steven
4 Replies
Anonymous thanks for your reply. One example, I have a slicer as a dropdown with the value 'PCProjectItem[Code]'
I would like to create a measure that selects for example'PCProjectItem[Code]' = "Concrete"
'PCProjectItem[Code]' = "Rebar"
'PCProjectItem[Code]' = "Lifters"etc etc
Then when I would apply this measure to the slicer my options would be the above filtered values. I also have multiple visuals that I would like to apply this measure to, instead of manually applying the filters to each visual.
