Compile monthly resource capacity

Hi, Prath 

According to your description, I can roughly understand your requirement, I think you can try my measure to achieve this:

First, you should delete the relationship between the calendar table with the main table to avoid errors.

Then create a measure like this:

Capacity1 =

var _value=

CALCULATE(SUM(Data[Capacity]),FILTER('Data',[Start]<=MIN('Calendar_Date'[Date])&&[End]>=MAX('Calendar_Date'[Date])))

return

IF(_value=BLANK(),0,_value)

Then create a matrix and place it and apply a filter like this:

And you can get what you want.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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