Filter a table by the minumum value of a column in DAX

[nr63bi]

Hello,

In DAX, I'd like to select a table filtered by the minimum value of a column. Here's how the table is determined

A B C 

1 0 Red

2 0 Red

2 1 Blue

2 2 Blue

3 1 Blue

3 2 Red 

A is the table identifier, B is the column from which I want to filter by the minimum, and C is an auxiliary column that I want to keep as is.

As a result, I would like to

A B C

1 0 Red

2 0 Red

3 1 Blue

I'm trying SUMMARIZE and LEFTJOIN but I'm not getting the results I want. What can I do?

Thanks in advance for your help 

[Anonymous]

Hi @nr63bi ,
Try creating a table using the below DAX

Table = SUMMARIZE(Table4, Table4[A], "B", MIN(Table4[B]), "C", CALCULATE(MAX(Table4[C]), Table4[B] = MIN(Table4[B])))

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!