I have a matrix visual. I am trying to filter based on specific values based on the columns.
There are about 20 different statuses. Users want the ability to select all values where the Intransit amount is a certain value while StillToBeCaptured is a certain value for example. Users should be able to select any value in any of the different stock statuses.
The problem is that my initial table has the statuses and amounts going down.
I was thinking of creating different measures for each but then there are slicers for measures. If I use a calculated column it taks it on the lowest level but I need it to be at the level of the rows.