cancel
Showing results for
Did you mean:

## Get the lowest cost and name from a group

I have a table with 3 columns.  I need to output the min cost for product by scenario and lowest cost product.

I have tried MINX and Grouping but I am unable to get all I need

5 REPLIES 5
New Contributor

## Re: Get the lowest cost and name from a group

This will give you the minimum cost for each scenario. Is that what you are asking for?

```Min Cost By Product and Scenario =
CALCULATE(
MIN('DataTable'[Total Cost]),
ALL('DataTable'[Product])
)```

Lowest product cost overall would be:

```Lowest Cost =
CALCULATE(
MIN('DataTable'[Total Cost]),
ALL('DataTable')
)```

## Re: Get the lowest cost and name from a group

Thanks!!

This is what I need yes but the last part would be to filter so that only the lowest combinations

Highlighted
New Contributor

## Re: Get the lowest cost and name from a group

`Lowest Cost Filter = (MAX('DataTable'[Total Cost]) = [Min Cost By Product and Scenario]) * 1`

Then add that measure to a filter and set it to only show when it is 1. If it is zero, then it isn't the lowest cost for that Scenario/Product combo. You have to multiply by 1 to convert True/False to 1/0 so it will be filterable.

## Re: Get the lowest cost and name from a group

For me this does not work becuase

`[Min Cost By Product and Scenario]`

is not a measure but a column.

New Contributor

## Re: Get the lowest cost and name from a group

A column how? A calculated column? It should be a measure. A column from Power Query? Why would you bring this data in this way as it won't recalculate as you filter/slice/add different contexts to a matrix.

It should be the measure I posted unless there is a really good reason to make it a column