Shadow filter

[Cyriackpazhe]

In this allselected(product[category]) should have a shadow filter for allselected to activate it right. Here there is a slicer, but where is the iterator that produces a shadow filter. 

[BeaBF · Accepted solution]

@Cyriackpazhe yes, an implicit shadow filter is applied in this scenario.

if it works, please accept the answer as solution

BBF

[BeaBF]

@Cyriackpazhe Hi!

If you want to ensure a shadow filter is explicitly applied, you should use:

SUMX(
VALUES(Products[Category]),
[Total Sales]
)

BBF

[Cyriackpazhe]

So is an implicit shadow filter applied here. 

[BeaBF · Accepted solution]

@Cyriackpazhe yes, an implicit shadow filter is applied in this scenario.

if it works, please accept the answer as solution

BBF

[Cyriackpazhe]

Which is the implicit shadow filter here. Could you elaborate that

[BeaBF]

@Cyriackpazhe 

CALCULATE(
[Total Sales],
ALLSELECTED(Products[Category]),
Products[Color]
)

BBF

[Cyriackpazhe]

sorry to bother you, I don't get it. Which is the shadow filter which is activated by allselected. There is a slicer, but a shadow filter to be used in Allselected?? 

[BeaBF · Accepted solution]

@Cyriackpazhe The shadow filter here is the filter applied by the slicer on Products[Category].
It is activated by ALLSELECTED(Products[Category]) because ALLSELECTED removes only row-level filters, not slicer filters.