Forum Discussion

peterso's avatar
peterso
Icon for Helper II rankHelper II
5 years ago
Solved

Return MIN value based on group

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.
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
5 years ago

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 🙂 

  • peterso's avatar
    peterso
    Icon for Helper II rankHelper II
    5 years ago

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

    • jameszhang0805's avatar
      jameszhang0805
      Icon for Resolver IV rankResolver IV
      5 years ago

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

      • peterso's avatar
        peterso
        Icon for Helper II rankHelper II
        5 years ago

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