Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to get multiple Slicer selections to variable?

Hello there,  I have a slicer with 5 options: Bing, Facebook, Google, NewTraffic and SteelHouse. I am trying to get selected value from the slicer into a variable. I am able to get it correctly if ...
Tutorial Requests
  • Duia's avatar
    Duia
    4 years ago

    Hi  Anonymous ,

    I created some data:

    Here are the steps you can follow：

    1. Create measure.

    Measure =
var _selelct=SELECTCOLUMNS('PlanDataSources',"select",[DataSource])
return
CALCULATE(
    SUM('PlanDataSources'[RevenuePlan]),FILTER(ALL(PlanDataSources),
    'PlanDataSources'[DataSource] in _selelct))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Duia's avatar
Duia
Resolver II
4 years ago

Hi  Anonymous ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _selelct=SELECTCOLUMNS('PlanDataSources',"select",[DataSource])
return
CALCULATE(
    SUM('PlanDataSources'[RevenuePlan]),FILTER(ALL(PlanDataSources),
    'PlanDataSources'[DataSource] in _selelct))

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly