Using Multiple Measures in a Switch

[mgtaylor33]

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?

[parry2k]

@mgtaylor33 glad it was helpful. Cheers!!

[mgtaylor33]

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.

[parry2k · Accepted solution]

@mgtaylor33 I hope this video will help: