Looking for DAX to get max value of measures

[MonkeySam]

Hi All,

I am looking for a way to get the max value from Measures.

I have a set of two tables containing daily transactions and the team list who serves the assigned customers. I have created a Measure (Metric Score %) to see the performance per team by date, however, I also want to show the highiest and lowest performances within a day. The desired result as shown in the last two columns (Max Score % by Date, Min Score % by Date).

I have tried MAX or MAXX functions but never achieve this challenge. Can someone please help me out? Thanks.

My example Pbix file

[HotChilli · Accepted solution]

I think if you create MAXX and MINX measures in the following format, it should work:

MAXX(ALL(Team[Team]) , [Metric Score %])

[MonkeySam]

Hi HotChilli,

Thanks for the advice. It works for me so far!!