DAX - first occurs from a group of values and counting them

[Luk92]

Hi all,

I'm pretty new to DAX and Power BI and I've got a probem that I need to resolve. I'm trying to get 2 things from one table.
 Table, lets call it Tab1, looks like this:

I would like to create a measure to:
1. Check the earliest date when status1, status2 or status3 occurs 
2. Count when one of those values (status1, status2 or status3) occurs

It should look like that:

Could you help me? 🙂

[ThxAlot · Accepted solution]

Cnt Status.pbix

[Luk92]

Hi,

thanks for the solution 🙂 I have to admit that I've made a mistake when showing how I would like the resault table to look like. It's a small change, maybe you could help. I just don't want the ID 4 show in that table at all, because it dosen't have status that I want to count.

EDIT: Ok, I've got it 🙂 Just changed "0" in RETURN to BLANK().

[ThxAlot]

A small tweak does the trick