Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

find max number when selecting time slicer

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.

q4.PNG

 

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!

1 ACCEPTED SOLUTION
jthomson
Solution Sage
Solution Sage

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

View solution in original post

2 REPLIES 2
jthomson
Solution Sage
Solution Sage

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
Not applicable

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.