Dax

[Cyriackpazhe]

When make a selection on the slicer, the 3 colors are available on the matrix. When i add the measure, value for the colors which are not part of the slicer selection also become visible. Why is this??

[bhanu_gautam · Accepted solution]

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