Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
@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!
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
Thanks!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |