Forum Discussion
Dax
Cyriackpazhe The issue you're encountering is due to the use of the ALL function in your DAX measure. The ALL function removes all filters from the specified table or column, which is why the measure is returning values for all colors, even those not selected in the slicer.
To ensure that the measure respects the slicer selection, you should remove the ALL function or use a different function that maintains the slicer context. For example, you can use the REMOVEFILTERS function selectively if you need to clear filters from specific columns but not others.
Cyriackpazhe The issue you're encountering is due to the use of the ALL function in your DAX measure. The ALL function removes all filters from the specified table or column, which is why the measure is returning values for all colors, even those not selected in the slicer.
To ensure that the measure respects the slicer selection, you should remove the ALL function or use a different function that maintains the slicer context. For example, you can use the REMOVEFILTERS function selectively if you need to clear filters from specific columns but not others.