Forum Discussion

NewbNeedHelp's avatar
NewbNeedHelp
Icon for Helper I rankHelper I
3 years ago

Slicers Only Affect Certain Columns in Matrix

Hello!

 

I may be making this more difficult than I need to, but I need to have a matrix where I need to have very specific columns and in a specific order. Also, one of my slicers (Brand) needs to only affect certain columns, as opposed to all columns. So I've set up a measure for each column, and used REMOVEFILTERS to remove Brand from all measures except the ones I want the Brand slicer to affect.

 

I feel like I'm ALMOST there, because it does work for certain instances. I've described in red when it works and when it doesn't work. Here is a WeTransfer link to my Desktop file: https://we.tl/t-AzSrRVHcSt (I can't upload because I'm new!).

 

Thank you in advance for any help!!