topic Re: How can I get MAX or MIN value from a measure? in DAX Commands and Tips

How can I get MAX or MIN value from a measure?

merep — Tue, 22 Nov 2022 13:15:27 GMT

I am currently working with measures in a financial data structure in PowerBI, and I need to get the minimum value of a measure that's previously calculated to show in a graph.

The measure I need to get the minimum from is calculated from another measure that represents the accumulated costs of the various suppliers of a business.

The image attached is the representation of the measure I need to get the minimum value of (ABC FILTER MAX A) and the name of the supplier. I tried to set a measure as 'MIN([ABC FILTER MAX A])' but it says I can only pass a column as an argument. Is there a way to do what I'm trying to do?

Thanks in advance!

Re: How can I get MAX or MIN value from a measure?

johnt75 — Tue, 22 Nov 2022 13:56:22 GMT

You need to break the measure down by supplier name. Try

Minimum value = MINX( VALUES( 'Table'[Account Description]), [ABC FILTER MAX A])

Re: How can I get MAX or MIN value from a measure?

FreemanZ — Tue, 22 Nov 2022 13:57:23 GMT

indeed, the result of measure is typically a single scalar value instead of a list of values. MIN expects to work on a list of value (a column). So in your case, suggest to add a calculated column in your table, than MIN that column.

There are other ways that can save the intermediate calculated column, like MINX.