Forum Discussion
Cyriackpazhe
Helper III
Helper IIIShadow 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.
BeaBF
Super User
Super UserCyriackpazhe Hi!
If you want to ensure a shadow filter is explicitly applied, you should use:
SUMX(
VALUES(Products[Category]),
[Total Sales]
)
BBF
CyriackpazheHelper III
Helper IIISo is an implicit shadow filter applied here.
- BeaBF
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