topic Re: Minimum of a calculated column in DAX Commands and Tips

Minimum of a calculated column

barron2020 — Tue, 12 Nov 2019 05:04:22 GMT

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 — Tue, 12 Nov 2019 05:20:03 GMT

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

Greg_Deckler — Tue, 12 Nov 2019 05:24:13 GMT

Sorry, I was a bit off:

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

See Page 5 and Table 8 of attached.

barron2020 — Sat, 16 Nov 2019 06:04:47 GMT

It worked. Thanks