Filter and slicer result

[JimmyCruyp]

Hello, I am looking to create a formula that calculates a sum for certain attributes in a list of attributes based on whether or not I have selected those attributes in a slicer. I want a different result depending on whether they are selected or not. If they are selected, I want the sum of their values. If they are not selected, I want the values to be 0 for each attribute. If they are not selected, I still want them to appear in my result table, so I need to remove the interaction so that the slicer does not filter my result table. I want all attributes to appear in my result table, even those that are not selected, but with a value of 0 for those that are not selected. There are 100 attributes in the list, so I should not name them in my formula. There are sometimes multiple values for each attribute, so the sum needs to be calculated.

[tamerj1]

@JimmyCruyp 
In this case the Attribute slicer has to come from a dim table. Just create a dim table with all unique attributes and connect it to the main table then use the column from the dim table in the slicer. It should work if add (+ 0) to your measure.

[JimmyCruyp]

I would like to find a solution without creating an additional table if possible?

[andhiii079845]

No it is not possible. Try this:

Measure 2 =

VAR _sum = sum(Source[Value])

VAR _select = VALUES('Table'[Attribut])

RETURN if(SELECTEDVALUE(Source[Attribut]) IN _select,_sum,0)

[JimmyCruyp]

Thanks, I tried this but only one table and it doesnt work. So there is no solution to do that without creating an additonal column?

[andhiii079845]

No, because you want the filter the column and also modify the filter context. This is not possible. 

[andhiii079845]

Can you please make a good data example with the underlaying data how with 1-2 different slicer value and how it should look like? Thank you 🙂

[JimmyCruyp]

For example if I filter in a slicer on attribut B and E (if I select only these attributes in my slicer)