How to sum multiple values if selected by slicer

Galvones — Mon, 15 May 2023 13:00:10 GMT

Dear Community,

I have 10 suppliers which are evaluated by 10 different categories, in a 0 to 1 scale, and I'm trying to add their evaluations in each category based on a multiple selection slicer, to show and compare that addition into a stacked column chart. It's given me a lot of trouble to try and figure out how to do it.

I managed to do it in a little scale using binary values in a table, and a measure which defines the sum for the values (for example, "Capacity" = 1, "Cash" = 2, "Clean" = 4, "Commitment" = 8, ando so on), combining it with a Var and Switch functions, as follows:

It worked, in a way. But for all 10 categories, the final code had 1024 lines for the SWITCH function, and that is too much memory used for most computers in which I tried to do it.

My question is: Is there another way to do the same thing, but through other functions? Or can I do something like that in a way that needs less memory?

Thanks.

topic How to sum multiple values if selected by slicer in DAX Commands and Tips

How to sum multiple values if selected by slicer