Include the min Date in Summarize

[daxnoob]

Hi, Is it possible to include the distinct min date value in a summarize measure?

Here is my code:

Countx(
         Summarize(
                 'Table',
                 'Table'[Name],

                 min('Table'[Date]),
                 'Table'[Age]),
         [Measure]
)

Obviously, this won't work but the table is set up where there can be multiple dates for each distinct name and I'm only trying to group each column with the minimum date value. Is that possible?

Thank you.

[Ahmedx · Accepted solution]

Is this what you are looking for?

Countx( FILTER(
         Summarize(
                 'Table',
                 'Table'[Name],
                 'Table'[Date])
                 'Table'[Age]),'Table'[Date]=min('Table'[Date])),
         [Measure]
)
----------
or
Countx( FILTER(
         Summarize(
                 'Table',
                 'Table'[Name],
                 'Table'[Date])
                 'Table'[Age]),'Table'[Date]=STARTOFMONTH('Table'[Date],0)),
         [Measure]
)

[ryan_mayu]

could you pls provide the sample data and expected output?