Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |