Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
glauberdmo
Frequent Visitor

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:

MyTable.png

 

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

filters.png

 

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?

 

1 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

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

View solution in original post

4 REPLIES 4
v-cherch-msft
Employee
Employee

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.

 

1.png

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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!

ChicletSlicer falling.png

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

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.