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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

I am sure this is possible.

Could you please share some sample data and explain this a bit in detail.

Thanks.

  • 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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi sanderson82 ,

      If you could send some sample data it would help me implement this.

      Thanks,