topic Return MIN value based on group in DAX Commands and Tips

Return MIN value based on group

peterso — Mon, 22 Feb 2021 13:24:41 GMT

Hi all,

Having some trouble with this... I'd like to add a measure to a visual that will allow me to plot the cost based on the minimum value for each type.

Thanks in advance.

Re: Return MIN value based on group

jameszhang0805 — Mon, 22 Feb 2021 13:55:46 GMT

Re: Return MIN value based on group

AntrikshSharma — Mon, 22 Feb 2021 14:13:51 GMT

jameszhang0805 Nice solution, a suggestion if you don't mind, use aggregation function such as MIN/MAX instead of VALUES to prevent the code from breaking in case there are duplicate Value for Type 🙂

Re: Return MIN value based on group

jameszhang0805 — Mon, 22 Feb 2021 14:18:12 GMT

AntrikshSharma Thanks for your suggestion, you are correct.

Re: Return MIN value based on group

peterso — Mon, 22 Feb 2021 15:05:13 GMT

Sorry I should have specified - I would like to only keep the rows that include the highlighted cost. Is this possible?

Re: Return MIN value based on group

jameszhang0805 — Mon, 22 Feb 2021 15:14:18 GMT

just remove the filer(all(Table)),from the calculate argument

Re: Return MIN value based on group

peterso — Mon, 22 Feb 2021 15:18:59 GMT

I received an error when adding the measure to a visual "A table of multiple values was supplied where a single value was expected"

Re: Return MIN value based on group

jameszhang0805 — Mon, 22 Feb 2021 16:49:50 GMT