Forum Discussion
How to output multiple selections on a single chart using a switch statement
Hi, So I have some selection buttons created from a switch statement in my report. The statement I have used is the following; Selection = SWITCH( TRUE(), VALUES( 'Metric Selection'[Metric...
MeasureQuality = IF(Selected value('Metric selection'[Metric]="ALL"); Quality[TotalAvgQualityperAgent];
Blank()
)Then include an "ALL" button aswell?
Thank you. This logically sounds promising. However I am receiving error when adding both to the values pane;
Ive tried changing the blank() to 0 but this still prompts same error. Any ideas?
tex628
Community Champion
Community ChampionMeasureQuality =
IF(Selected value('Metric selection'[Metric]<>Blank());
Blank();
Quality[TotalAvgQualityperAgent]
)Try this! :)
- tex628
Jesus, im not paying attention... like this instead:
MeasureQuality = IF(Selected value('Metric selection'[Metric])<>Blank(); Blank(); Quality[TotalAvgQualityperAgent] )lol yep I did sus it, hence I deleted my post.
So looks like it tries to pass in multple values from 'Selection' when not choosing anything. See below;
I would have thought this would default to 0 if no value/selection was chosen as per my switch statement above. Any ideas?
(btw thanks for all your help thus far)
- tex628
MeasureQuality = IF(Selected value('Metric selection'[Metric]="ALL"); Quality[TotalAvgQualityperAgent];
Blank()
)Then include an "ALL" button aswell?