topic How to customize measure with several selection in a slicers in DAX Commands and Tips

How to customize measure with several selection in a slicers

arq52 — Mon, 03 Aug 2020 17:18:53 GMT

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.

Re: How to customize measure with several selection in a slicers

Greg_Deckler — Mon, 03 Aug 2020 17:26:14 GMT

arq52 - Perhaps take a look at this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444

Re: How to customize measure with several selection in a slicers

arq52 — Mon, 03 Aug 2020 17:39:01 GMT

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.

Re: How to customize measure with several selection in a slicers

arq52 — Tue, 04 Aug 2020 06:58:28 GMT

Hello,

I've find the solution of my issue 🙂.

My SlicerTable :

Show

[new measure]=

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

"D";[Measure D]
)
)