Forum Discussion

mgtaylor33's avatar
mgtaylor33
Frequent Visitor
2 years ago
Solved

Using Multiple Measures in a Switch

For this example:

 

Creating 3 Groups of Measures, of which each group will have 3 or 4 Measures..

 

I would like to have a switch to choose between the 3 groups, so that when I choose one...  all measures in that Group

 will appear in my , lets say matrix visual..

 

so 1 Group would be called DOT, holds Dot Total, Dot Failure, DOT Success.  

2 Group would be called    b4_10, holds b4_10 Total, b4_10New, b4_10Old 

 

group 3, 4 and 5   various other measures..

 

WHat I'd then like to have is a filter visual that will list Group 1 through to x

 

when i choose Group 1... the matrix  will have DOT Total, DOT Failure, DOT Success as eother a ROw or Column  dependant on where I have put the 'Parameter" of the switch...

 

Is this do-able?

3 Replies

  • mgtaylor33's avatar
    mgtaylor33
    Frequent Visitor

    Absolutely...  that will totally work with what I am after....  the key to this was the ADD Column and the if statement , as I had the field Parameter set, just needed the method to have a group name rather than  all measures showing.

     

    Brilliant thank you.