Slicer: Multiple selection

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

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