count events in progress steps needed

Hey,

I guess that one of the articles you already have been reading is this one:

http://sqljason.com/2012/11/classifying-and-solving-events-in.html

Without sample data it's very difficult to say what's not working with your formula.

I created a little PBI sample file and I adjusted your Formula to my data model and it seems to work, at least I get what I expected :-)

I assume you created a measure in your fact table and used the relevant date columns from your unrelated date table.

If my sample and the article from Jason Thomas does not help, I guess you have to create sample data, upload a file to onedrive or dropbox and share the link.

Regards

Tom