Forum Discussion

JemmaD's avatar
JemmaD
Helper V
3 years ago

Create a switch statement to create a dynamic title showing lowest level of detail

I have a report with four filters which form a heirarchy in themselves from highest level of detail to lowest level of detail.

My report users can pick from one, or all four of the filters.

Say the filters are called

Level1
Level2
Level3
Level4

 

I need to create a title measure which says if Level1 is selected, show Level1. If Level1 and Level2 is selected, show Level2 and so forth. So the user may have selected from all four filters, but the measure will only show the value in Level4.

Second complexity: the user may select multiple options from any of the levels. If they do this, I want the title message to say "Please only select one". If nothing is selected, I want the title message to say "Unfiltered".

I think I need a IF(HASONEVALUE argument, and I think I need SWITCH and TRUE() arguments but I have no idea how to build this. 

The table that the filters are in is called 'Broker'

Can anyone help me build a measure? 

Need Help

2 Replies

  • Shreeram04's avatar
    Shreeram04
    Resolver III
    3 years ago

    Hi JemmaD 

     

    Try a Quick Measure called "Concatenated list of values".

     

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it.

     

    Thanks,

    • JemmaD's avatar
      JemmaD
      Helper V
      3 years ago

      Shreeram04  this isnt' what I want at all, I don't want them concatenated and this allows for a single field not four. Thanks anyway