Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
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
Thanks a lot, it helps and solves the issue. Appreciate that!
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
54 |