Minimum Value of a column based on other column vlaue

[Darrellfone]

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 · Accepted solution]

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 · Accepted solution]

Hi @Darrellfone ,

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.

[Jihwan_Kim · Accepted solution]

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.

[Darrellfone]

Thanks 

I have managed to solve the issue now TVM 🙂 😀