Max ID in table

[Anonymous]

Hi, I have a Dim_Period and I'm trying to retrieve the max Week ID for the table in Power BI. How should I get the max ID and not getting filtered by Week column?

The value in Week column will change in Power BI depending on which Fiscal Quarter I select.

Regards,

BK

[amitchandak · Accepted solution]

@Anonymous , New measure without filter

maxx(all(Table), Table[Week])

with filter

maxx(allselected(Table), Table[Week])

New column, it will not take slicer value

maxx(Table, Table[Week])