Creating a table with filtered values using a date from and date to

hi MarioJoseb1980 ,
I delete the relationship and edit the DAX formula.

Filter_date = 
VAR dat = SELECTEDVALUE('100 HORAS CRITI'[Date])
VAR hou = SELECTEDVALUE('100 HORAS CRITI'[Hour])
VAR filter_dat = FILTER('Event_Table', 'Event_Table'[Start Date] <= dat && 'Event_Table'[Start Hour] <= hou && 'Event_Table'[End Date] >= dat && 'Event_Table'[End Hour] >= hou)
RETURN
CALCULATE(SUM('Event_Table'[Generation reserve]), filter_dat)

The result is shown below.

You need to be a super user to attach files on messages.

Solved: How to upload PBI in Community - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.