Maximum Value of a Dynamic Measure

Good day everyone! Would anyone know how to create a measure that returns the maximum value of a dynamic measure?

Example:

**note that sales, unit, and sales/unit are measures and respond to whatever is showing in the market field

**Market field is linked to a filter so values are changing

What i want is to have a measure that will return the value 25. Let me know if this is possible. Thanks!

try this measure

Max sales = 
VAR _max = MAXX(ALLSELECTED(Tablename[Market]),[Measure])
RETURN _max

Thanks,

Arul

try this measure,
Measure = MAXX(ALLSELECTED('table'[MARKET]),[UNIT/SALES])

Forum Discussion