Countifs in DAX

[MrJoosten]

Hi Guys,

I have some problems with counting ID's that meet 2 conditions but on a different row. Can someone help me out with a formula? See the table below for example.

Thanks a lot!

ID

ID	Condition 1	Condition 2	If ID meets condition 1 and 2 then return ID, else return blank
1001	1	0	1001
1001	0	1	1001
1002	0	1
1002	0	1
1003	1	1	1003

 

[MrJoosten]

Edit: even better would be 1 measure to sum distinct-count ID's that meet both conditions.