Using Anti filtering with Chiclet Slicer (like ALL or ALLEXCEPT)

[glauberdmo]

Filtering a column with a Chiclet Slicer or Slicer gave me different results when I tried to ignore a filter using ALL

Example:

Using a sample the table  MyTable:

And a Slicer and a Chiclet Slicer with The Field "Marca" at each one:

Using a measure "Measure" in another table:

Measure = CALCULATE(MAX(MyTable[Field1]);ALL(MyTable[Marca]))

Results with Slicer:

Give me the max value of the field "Field1" ignoring the filter Marca (Right!)

But using Chiclet Slicer.:

Give me the max value not ignoring the filter Marca (Wrong...)

So, how to use ALL & ALLEXCEPT with Chiclet Slicer? There is a way?

[v-cherch-msft]

Hi @glauberdmo

Based on my test, you may get the max value of the field "Field1" ignoring the filter Marca when using Chiclet Slicer as below picture. If it is not your case, please explain more about your expected output.

Regards,

Cherie

[glauberdmo]

@v-cherch-msft Making the same, brings me same results as you (my expected output), but just adding pictures in chiclet slicer, the results changes!

The only difference of our example is the Field "Link".

I used the pictures from this site

Please, try to put some pictures in your example and test if it continues to work.

Thanks for your answer!

[OwenAuger · Accepted solution]

Hi @glauberdmo

When making selections on a Chiclet Slicer wih images, both the Category and Image fields are added to the filter context.

In your example, to remove the effect of the Chiclet Slicer, you would need to remove filters on (at least) both the Marca and Link columns.

Try this measure:

MeasureA =
CALCULATE ( MAX ( MyTable[Field1] ); ALL ( MyTable[Marca]; MyTable[Link] ) )

Regards,

Owen

[glauberdmo]

Thanks!