Does converting Product Type to a Table Calculation (LOOKUP) filter resolve the problem (not sure how well this will work if you have more dimensions in play, etc.) for you?
I am not 100% certain I interpreted the problem correctly, so I could be way off here.
See the attached.
Seasonal ML.twbx 15.3 KB
1 of 1 people found this helpful
Interesting solve Matt, thanks!
I do have about 4 filtered dimensions in my real example across about 20 sheets using 5 different datasources so it could be a bit of a challenge to implement but I will evaluate later today and check it out.
I did use this on my own problem that I had with my workbook.
There were many options on the dimension and I did that lookup for the dimension.
After that, I got a #missing -value for the dimension.
Solution was to filter a filter on quick filters with a duplicate of that dimension.
Drag the original dimension to quick filter and exclude or untap the #missing value:
Drag the duplicate of that dimension to quick filter dimension and click option Use all
Use the duplicate dimension as filter (show filter). You should not see no more #missing on the filter menu.
Hmm.. Actually I am still having the same problem.
I am chancing the dimension values through parameter, so the lookup is chancing all the time.
And it does not sort the month\year value accordingly