topic Re: Minimum Value of a column based on other column vlaue in DAX Commands and Tips

Minimum Value of a column based on other column vlaue

Darrellfone — Tue, 19 Nov 2024 14:17:30 GMT

Hi there

I am new to PowerBI so please excuse the simplicity of my question

I have returned data I need to display in to the PowerBI report and can do simple Transformation routines.

However I have too much data and now want to only show the minimum Value of column B based on the value in column A

Simple data set

Column A Row 1 = W-001 Column B = 20

Column A Row 2 = W-001 Column B = 30

Column A Row 3 = W-001 Column B = 40

Column A Row 4 = X-002 Column B = 80

Column A Row 5 = X-002 Column B = 90

Column A Row 6 = X-002 Column B = 100

I want to filter this data so that I only see

Column A Row 1 = W-001 Minimum Value Column B = 20

Column A Row 2 = X-002 Minimum Value Column B = 80

Any help would be appreciate

Best regards Darrell

Jihwan_Kim — Tue, 19 Nov 2024 17:27:13 GMT

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create a sample pbix file like below.

Anonymous — Wed, 20 Nov 2024 01:39:40 GMT

If you need to create measure, you can use the following expression:

Measure = CALCULATE(MIN('Data'[B]),ALLEXCEPT('Data','Data'[A]))

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Darrellfone — Wed, 27 Nov 2024 10:23:18 GMT

Thanks

I have managed to solve the issue now TVM 🙂 😀