Search for answers here or ask a question
0

Variable List Measure, of a Variable List Measure

Some of our colleagues demo'd a dashboard where they had two parameters, one of which drove the visual i.e. a variable measure. 

 

They had 4 groups of measures, profit, reserving, claims and premium. The first parameter showed these measures and depending on what they selected i.e. profit then the second parameter would show a set of measures the user could select, so rather than having one parameter with 12 measures , they had 2 parameters with 4 sets of 3.

 

How would I go about doing this? I tried with a basic version, but I can't get that to work, see below?

 

  

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Ian MacdonaldAdmin
    • Team Lead - Product Management
    • Ian_Macdonald
    • 6 mths ago
    • Reported - view

    Hi Nicholas,

    You're nearly there!

    Create a Global Parameter set as discrete options and add the text and returning value you need:

    Create a dynamic list, using the Switch function an the global variable. For each switch option add a Measure list of the measures you want to group into that option:

    Create a Parameter and use the dynamic list created above to populate the Parameter:

    Select the Parameter for your report:

    Hope that helps.

    Ian

    Like
  • Thanks Ian as usual very easy to follow and understand and helped massively :)

    Like
Like Follow
  • Status Answered
  • 6 mths agoLast active
  • 2Replies
  • 28Views
  • 2 Following