Filter category column based on the earliest date

[yog1405]

Hello community

I am new to power bi and need help!

I have two tables: Case and Event. A case can have many events. 

I would like to create a table visual using three columns (for simplicity): case id (case table), event type (event type), and event date (event table). When I drag and drop the three columns, I get duplicates case ids for each event type and their corresponding date. But I would like to achive is display case id (no duplicates), event type, earliest event date.

This is what I get when I drag and drop three coulmns from the case and events table

But What I want acheive is the following

thanks in advance 🙂

[yog1405]

Thank you very much @smpa01 

[smpa01 · Accepted solution]

@yog1405  please use the following measure

Measure =
CALCULATE (
    MIN ( Event[date] ),
    FILTER (
        Event,
        Event[date]
            = CALCULATE ( MIN ( Event[date] ), ALLEXCEPT ( Event, Event[case id] ) )
    )
)