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??
@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.
Proud to be a Super User! | 
|
@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.
Proud to be a Super User! |
|
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
