Forum Discussion

sanderson82's avatar
sanderson82
Helper I
7 years ago

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 ...
Need Help
sanderson82's avatar
sanderson82
Helper I
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

You can do this by creating a bookmark as a filtered. Then you can have an option of 'remove filters' and have one more bookmark for the unfiltered report.

Thanks.