Here’s exactly what you need for this.
It’s called the ‘events in progress’ pattern.
It’s very important to get the model and relationship set up correctly for this, as well as the DAX measures.
Everything is explained in the video. Should solve it.
Chrs