Selecting Multiple Measures using Selected Column

[Kolumam]

Hi All,

I have three measures and I have converted the measure to a slicer using selected column and selected value function. Now when I select one measure, it plots a graph. When I select multiple measures, it doesn't show anything.

Dynamic Selection = VAR selectedcolumn = SELECTEDVALUE(Parameter[Id])
RETURN
SWITCH(
    TRUE(),
    selectedcolumn = 1, CALCULATE([Cumulative Size Operating - planned]),
    selectedcolumn = 2, [Cumulative Size Operating],
    selectedcolumn = 3, [Cumulative Size Won])

See below images:

If I select one measure, it shows the graph.

If I select multiple measures, it doesn't show anything. How do I adjust the above DAX to show both the line graphs.

[jdbuchanan71 · Accepted solution]

Hello @Kolumam 

You have to add your Parameter[Id] field to the legend in the chart.  That way SELECTEDVALUE() won't be getting multiple responses, when it does it returns BLANK().  Because the Parameter[Id] is now in the chart SELECTEDVALUE() can split up the lines.

You could also change your code so that rather than putting the ID in the legend, you can put the measure name in the legend which will help the users know what each line represents.

Dynamic Selection = VAR selectedcolumn = SELECTEDVALUE(Parameter[Measure])
RETURN
SWITCH(
    TRUE(),
    selectedcolumn = "Cumulative Size Operating - planned", CALCULATE([Cumulative Size Operating - planned]),
    selectedcolumn = "Cumulative Size Operating", [Cumulative Size Operating],
    selectedcolumn = "Cumulative Size Won", [Cumulative Size Won])

[Kolumam]

Awesome! It worked. Thank you!