How to remove the date context from a measure

[o59393]

Hi all

I have the following table which gives me the start-up date of a project and its respective production capacity.

The issue I have is that the capacity value is just the month of the start-up. Instead, I need to have is the year to date production capacity. 

In the table above the 1.4 MM value is for Sept 2024, but instead I need to have the value from sept 2024 to dec 2024. 

I tried this dax but it returned me the same 1.4 MM UC.

Capacity YTD = 

CALCULATE(
    [Capacity UC],
    DATESYTD(
        'Hours by line - Official'[Start-Up Date]
    )
)

And also tried with ALL but it returned me 94 MM which equals to the period from jan 2024 to dec 2029. .

Capacity FY = 

CALCULATE(
    [Capacity UC],
    ALL(
        'Hours by line - Official'
    )
)

Any idea how to solve this?

Thanks.

[PijushRoy]

Hi @o59393 

Please use REMOVEFILTER in place of ALL, find example
https://dax.guide/removefilters/

https://learn.microsoft.com/en-us/dax/removefilters-function-dax

If your requirement is solved, please make sure to MARK AS SOLUTION and help other users find the solution quickly. Please hit the LIKE button if this comment helps you.

Thanks
Pijush