How to get the MAX of a measure in DAX?

[Anonymous]

I have a measure called [Staff Performance] which is simply DIVIDE([Measure A], [Measure B])

On a matrix visual, this [Staff Performance] measure displays correctly = at daily and weekly levels.

The matrix has a drill-down hierarchy of Manager -> Staff -> Week -> Day. When the data displays at Manager level, I would like the a measure that will be the MAX([Staff Performance]) across all of the staff under the manager. 

But when I try this measure

Best Staff Performance := MAX([Staff Performance])

I receive an error: The MAX function only accepts a column reference as an argument.

How can I write a measure to do this?

[amitchandak]

@Anonymous ,

something like this

Best Staff Performance = calculate(MAX([Staff Performance]), allexpect(Table[Manager]))

in case you need to build hierarchy using the path , refer -https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

[mahoneypat · Accepted solution]

You can use this approach with MAXX().  This should give you the max employee for each Manager, and the overall MAXX in the "Total".

Max Employee Value = MAXX(VALUES(Table[Employee]), [Staff Performance])

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat