Calculate Open Events Using Date Ranges

[freshwave]

We have a table that contains our events and we would like to be able to calculate how many open events per date to use on graphs.  We want to generate the open events for all calendar days, not only days that exist in the events table.  I can easily calculate this in excel which you can see from the attached image.  Maybe it is simple, though I can't seem to figure it out.

Any help would be appreciated.

 

[Greg_Deckler · Accepted solution]

Maybe something like:

Measure = CALCULATE(COUNTROWS(Table),FILTER(Table,Table[BeginDate]>=MAX(Dates[Date]) && Table[EndDate] <= MAX(Dates[Date])))

Something like that.

[freshwave]

Thanks that worked well.  Guess the date table cannot have a relationship with the events table, otherwise it starts to filter down.