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?

 

  

2 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 2 yrs 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

    • Nicholas_Campbell
    • 2 yrs ago
    • Reported - view

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

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 2Replies
  • 49Views
  • 2 Following