How to customize measure with several selection in a slicers

[arq52]

Hello,

I have several measures : [measure A], [measure B]; [measure C], [measure D].

I have created a table with the corresponding texts :

measure A

measure B

measure C

measure D

and a slicer linked to this table.

I would like to be able to select several values in this slicers and then, use this information to calculate a new measure that will sum each selected measure.

If I select A and C, my new measure will be [Total] = [measure A] + [measure C]
If I add D to the current selection, I want that [Total] = [measure A] + [measure C]+ [measure D]

I know how to do that with one dedicated slicers per measure, but I would prefer the approach with just one slicer.

Can you help me ?

Thanks by advance.

[Greg_Deckler]

@arq52 - Perhaps take a look at this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titl...

[arq52]

Thank you for your help,

But at "step 1", this is the usual selection of a single value (distribution or price or value or volume).

And not several values selected in one slicers.

Best regards.

[arq52 · Accepted solution]

Hello,

I've find the solution of my issue 🙂.

My SlicerTable :

Show

A

B

C

D

[new measure]=

SUMX(SlicerTable;
  SWITCH(SlicerTable[Show];
    "A";[Mesure A];
    "B";[Mesure B];
    "C";[Mesure C];

    "D";[Measure D]
  )
)