Select rows with Minimum date in DAX Table

[nr63bi]

Hello, 

I have a problem in Power BI

I use Power BI (not Query) and in table, i want to return only rows by the min date of the key. 

For example

A 2/01 Blue

A 3/01 Red

A 5/01 Blue

B 3/02 Blue

B 5/04 Red

I want : A 2/01 Blue

             B 3/02 Blue

I tried to use SUMMARIZE but it only returns the key and the min date, and note the other columns like the color in my example. 

How can i return the entire row that contains the min date per key ? 

[Greg_Deckler]

@nr63bi Maybe:

Table =
  VAR __Table = SUMMARIZE('Table', [ID], "__Date", MIN('Table'[Date]))
  VAR __IDs = SELECTCOLUMNS(__Table, "__ID", [ID])
  VAR __Dates = SELECTCOLUMNS(__Table, "__Date", [__Date])
  VAR __Result = FILTER('Table', [ID] IN __IDs && [Date] IN __Dates)
RETURN
  __Result

[nr63bi]

@Greg_Deckler hey thank you i like the idea but it don't work

it returns me 100 000 rows and i expect 19 521 

(the distinct) 

[Greg_Deckler]

@nr63bi Try this:

Table =
  VAR __Table = SUMMARIZE('Table', [ID], "__Date", MIN('Table'[Date]))
  VAR __IDs = SELECTCOLUMNS(__Table, "__ID", [ID])
  VAR __Dates = SELECTCOLUMNS(__Table, "__Date", [__Date])
  VAR __Result = DISTINCT(FILTER('Table', [ID] IN __IDs && [Date] IN __Dates))
RETURN
  __Result

[nr63bi]

@Greg_Deckler 

I try another solution inspired by your answer

I use _IdDate= ADDCOLUMNS(_Table,"ID&Date",CONCATENATE(ID,Date)

In the original table i add the column CONCATENE ID,Date

and i filter like FILTER('Table',CONCATENETAIDDATE in IDDate)

But i have the error "invalid number of arguments, function CONTAINSROWS must have value for each expression of the table"

But  don't use containsrows