Filter to show an event in a date range and not in specific ones

[IliasKatsis]

Hello everyone, 

I have this kind of data, which refers to some events with a start and end date 

Bucket name is a short description! 

In my dashboard a have a table which returns all the active events for a specific date range.

The problem is that when i choose a @From_Date from the filter above the table, which is after the start date of the event, this events is not appeared in the table. Actually this event is active!

How these events with a From Date > Start Date can be shown in the table?
Thanks a lot !

[amitchandak]

@IliasKatsis ,

//Range is coming from independent table.  Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Start Date] <=_max && 'Table'[End Date] >=_min))

if range is coming from joined date tbale

new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[Start Date] <=_max && 'Table'[End Date] >=_min), crossjoin(Date[Date], Table[Start Date]))

refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[IliasKatsis]

I just want to show all the infomation about a bucket which are retirieved from a table. Each Bucket has a name, some aggragations and a start and end date. How is it possible to show all these infomation for the ranges i have already mentioned

[lukiz84]

Which measure do you use in the table?