Get the MAX of the measure based on filters applied

[Uzi2019]

Hi Expert,

I have one calculated measure on which I want to calculate MAX of this measure with respect to the filter selected by users.

Input fields:

Measure Name = Profit Measure

Filters/Slicers available = Region, Week, Channel

Output:

Max of the Profit Measure based on values selected by users in those filters

I would really appreciate your help.

P.S. I tried with MAXX along with ALLSELECTED/REMOVEFILTERS/SUMMERIZE but nothing worked.

[Tahreem24 · Accepted solution]

@Uzi2019 You can also try this measur:

Measure = MAXX(ALLSELCTED(TableName),[Profit Measure])

[amitchandak]

@Uzi2019 , Seem like @johnt75 has replied before me. So consider that reply before checking this. In case that does not solve the purpose, then consider this

You need to have something like this

Switch( True(),

selectedvalue(Slicer[Slicer])  ="Region", maxx(values(Table[Region]), [Measure]) ,

selectedvalue(Slicer[Slicer])  ="Week", maxx(values(Table[Week]), [Measure]) ,

selectedvalue(Slicer[Channel])  ="Week", maxx(values(Table[Channel]), [Measure])

)

[johnt75]

It depends on which column or columns you want to group by. If you are only grouping by 1 column then you could use

Max profit =
MAXX ( VALUES ( 'Table'[Column] ), [Profit] )

If you are grouping by more than 1 column then use

Max Profit =
MAXX ( SUMMARIZE ( 'Table', 'Table'[Column 1], 'Table'[Column 2] ), [Profit] )