Forum Discussion
Shadow filter
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.
Cyriackpazhe yes, an implicit shadow filter is applied in this scenario.
if it works, please accept the answer as solution
BBF
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.
7 Replies
Cyriackpazhe Hi!
If you want to ensure a shadow filter is explicitly applied, you should use:
SUMX(
VALUES(Products[Category]),
[Total Sales]
)BBF
So is an implicit shadow filter applied here.
Cyriackpazhe yes, an implicit shadow filter is applied in this scenario.
if it works, please accept the answer as solution
BBF
