Looking for DAX Help for a Count of Orders After Event Order Date

[Anonymous]

Hello All,

I am looking to get a count of orders by account. I have an example of the columns i have below. 

More specificly im looking for a formula that would look at each account  and give me a count of orders after the order a specific event. 

Account	OrderKey	Event ID	Event Date	Order Date
abc1	55	111	1/1/2021	1/1/2021
abc2	56	112	4/1/2021	3/25/2021
abc3	57	112	4/1/2021	2/10/2021
abc1	58	112	4/1/2021	1/6/2021
abc2	59	111	1/1/2021	10/10/2021
abc3	60	113	10/1/2021	2/10/2021
abc1	61	113	10/1/2021	1/25/2021
abc1	61	114	11/1/2021	1/25/2021

So if i use a event id slicer and select Event ID "111"  the account abc1 would return the following 

	Slicer : Event ID 111
Account	Count of orders
abc1	3
abc2	0

Ive been racking my brain for a formula for quite a while and am just looking for a bit of guidence, 

Thank you for any help.

Adam

[CNENFRNL · Accepted solution]

[Anonymous]

Thank you very much for your help this worked for me!

[bcdobbs]

Are the event ids always in chronological order?

[Anonymous]

No they are not.  

[bcdobbs]

No problem can you explain a little more about why abc2 would have a count of zero? Think I'm missing something!

[Anonymous]

Of course, so abc 2 only purchased EventID 111  and did not purchase any other Event after that.