Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

how to get the max week number by ignored the data slicer but the week slicer still works

data source: one date table,

dashboard:  I have two slicers on one page, one is the date slicer and the other is the week number slicer , these two slicers are all the numeric range and can't interact each other( i set up the interaction), now I want to know the max week number in the week number slicer, how to write the measure. 


i don't know whether you can understand , 

Super User
Super User

@Cyouth , Hope they are not from the same table


Try a measure like

Maxx(allselected(Week[Week]), Week[Week])

but in this case ,they are from one table, so , whether we got a way to write the measure?

Helpful resources

Winner of T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Find out who won the T-Shirt Design Challenge and the top 3 finalists.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

Top Kudoed Authors
Users online (569)