Determine the maximum value of a measure

[Anonymous]

Hi, guys

I'm looking to write a DAX formula to determine the maximum value of the measure and find the X axis value associated with that.

The curve if that measure is plotted with the date will look something like this. Therefore, I am looking for a way to determine the maximum value (here 0.53M) and the date on which that number registered (apr 19 here). Can you help me find a way to do it?

Thank you

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

We can use the following measures to meet your requrirement.

MaxValue = MAXX(GROUPBY(ALLSELECTED(‘Table’),’Table’[X-Axis]),CALCULATE([Measure_Value]))

X-AxisOfMaxValue = MAXX(FILTER(SUMMARIZE(‘Table’,’Table’[X-Axis],”TempValue”,CALCULATE([Measure_Value]),[TempValue]=[MaxValue]), [X-Axis])

We create a sample and the result like this,

If it doesn't meet your requirement, Could you please show the exact expected result based on the tables that we have shared?

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

Hi @Anonymous ,

You need to use the MAXX function to get the number you are looking for.

You need something similar to:

MAximum = MAXX(Table, [Measure])

Be aware that the table need to be adjusted to your needs.