Minimum of a calculated column

[barron2020]

Hi Community,

I have a data set that looks like this:

SKU - Weight in Kg 

SKU1 - 50

SKU2 - 100

SKU3 - 150

SKU4 - 200

I have created a filter to select only weights between 95 and 160.

So, SKU2 and SKU 3 will be returned.

Now, I want to create a measured column that will find out the minimum of weight and find out the difference in weight.

For example, It should look like this

SKU - Weight - New Measure Column

SKU 2 - 100 - 100-100=0

SKU 3  - 150 - 150-100=50

Currently, when I do the measure, It is giving this result

SKU - Weight - New Measure Column

SKU 2 - 100 - 100-100=0

SKU 3  - 150 - 150-150=0

Measure column = min(Weight)

Please help

[Greg_Deckler]

You want a MINX coupled with an ALLEXCEPT('Table'[SKU])

[Greg_Deckler · Accepted solution]

Sorry, I was a bit off:

Measure 5 = MAX([Weight]) - MINX(ALLSELECTED('Table 8'),[Weight])

See Page 5 and Table 8 of attached.

[barron2020]

It worked. Thanks