Return MIN value based on group

[peterso]

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.

[jameszhang0805]

[AntrikshSharma]

@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 🙂 

[jameszhang0805]

@AntrikshSharma Thanks for your suggestion, you are correct. 

[peterso]

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

[jameszhang0805]

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

[peterso]

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

[jameszhang0805 · Accepted solution]