Forum Discussion

Frequent Visitor

7 years ago

Solved

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

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?

OwenAuger
7 years ago
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

4 Replies

v-cherch-msft
Microsoft Employee
7 years ago
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
  Frequent Visitor
  7 years ago
  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
    Super User
    7 years ago
    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

Related content