Forum Discussion

Gui_Gon's avatar
Gui_Gon
New Member
8 years ago
Solved

Slicer: Multiple selection

Hi all,   I'm working on a report and am finding some trouble to show some import/export data with multiple filter selection.    For instance: We have country 1, 2 and 3: Country 1 exports to co...
Need Help
  • Gui_Gon's avatar
    Gui_Gon
    8 years ago

    Hi Raj,

     

    Thank you for your answer, but I didn't unsderstood how can I do it. In the scenario I've mentioned, I'd have only 3 measure names (country 1, country 2 and country 3), however the fields that I intent to sum is different based on the selection that I can make.

     

     

    Does that make sence?

     

    Thanks,

    Guilherme

  • Anonymous's avatar
    Anonymous
    8 years ago

    1. Create DAX table)Ex: Table_Dax) with 1 column

     

    Prompt_Values

    =========

    Country1

    Country2

    Country3

    Country1&2

    Country2&3

    Country1&3

    Country1&2&3

     

    2. Create a slicer based on Table_DAX. Prompt_values

    3. Create Measure like this:

     

    Measure1=SWITCH( SELECTEDVALUE(Table_DAX[Prompt_values]),

    "Country1", <your calculation>,

    "Country2",<your calculation>,

    "Country3",<your calculation>,

    "Country1&2",<your calculation>,

    "Country1&3",<your calculation>,

    "Country2&3",<your calculation>,

    "Country1&2&",<your calculation>

    )

     

    Hope this helps.

     

    Thanks

    Raj

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

You will have to create a DAX table by entering the values. The DAX table will have 2 column, one is with the measure name that you want to display and another column(Say ColA) you can give some meaningful value.

 

Your slicer should be based on the ColA column values and based on the selection, you can use the measure dynamically. you need to use SELECTEDVALUE function for this.

 

Thanks

Raj

Gui_Gon's avatar
Gui_Gon
New Member
8 years ago

Hi Raj,

 

Thank you for your answer, but I didn't unsderstood how can I do it. In the scenario I've mentioned, I'd have only 3 measure names (country 1, country 2 and country 3), however the fields that I intent to sum is different based on the selection that I can make.

 

 

Does that make sence?

 

Thanks,

Guilherme

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    1. Create DAX table)Ex: Table_Dax) with 1 column

     

    Prompt_Values

    =========

    Country1

    Country2

    Country3

    Country1&2

    Country2&3

    Country1&3

    Country1&2&3

     

    2. Create a slicer based on Table_DAX. Prompt_values

    3. Create Measure like this:

     

    Measure1=SWITCH( SELECTEDVALUE(Table_DAX[Prompt_values]),

    "Country1", <your calculation>,

    "Country2",<your calculation>,

    "Country3",<your calculation>,

    "Country1&2",<your calculation>,

    "Country1&3",<your calculation>,

    "Country2&3",<your calculation>,

    "Country1&2&",<your calculation>

    )

     

    Hope this helps.

     

    Thanks

    Raj

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Raj,

       

      I followed the same senario for that multi selection in the slicer. but i am not able to select the multiple selections like. column1 and column2 and column3 at single selection.....

       

      Can yopu please help me on this.....