find max number when selecting time slicer

[Anonymous]

Hi I am trying to find the maximum of the "Distintcount of Date" across different Brand, Class, Part and SKU when selecting Year-Month slicer. 

I tried to use a MAX measure, but it is still grouped by different SKU.

I would like to see when selecting Year-Month slicer (e.g. 2018-01), the max date (measure) will show 23 for all 4 rows.

Any help would be greatlly appreciated!

Thanks!

[jthomson · Accepted solution]

Sounds like a job for ALLEXCEPT and the columns you actually need to filter on, that should then ignore the breakdown by SKU you're currently getting

[Anonymous]

Thanks a lot, it helps and solves the issue. Appreciate that!