Dax Query Slow - Need ideas to Optimize

[mtb1973]

Hello,

I am afraid I can't add a whole lot in the way of PBIX/Sample Data due to the fact that I love my job and don't want to get fired.
With that being said, does anyone have a potential better way to write the following? It, unfortunately is very slow.

Thanks

CALCULATE(
SUMX(
SUMMARIZE(
Dim_Date,
Dim_Date[FullDate],
"Budgets", [ShipDaysBudgetAllocation]
),
[Budgets]
),
FILTER(
ALLSELECTED( Dim_Date ),
Dim_Date[FullDate]
<= MAX( Dim_Date[FullDate] )
)
)

[AlexisOlson]

Is it necessary to iterate through each date independently for [ShipDaysBudgetAllocation] to work properly? How is that measure defined?

Unrelatedly, try this refactoring:

VAR SelectedDays =
    CALCULATETABLE (
        VALUES ( Dim_Date[FullDate] ),
        ALLSELECTED ( Dim_Date ),
        Dim_Date[FullDate] <= MAX ( Dim_Date[FullDate] )
    )
RETURN
    SUMX ( SelectedDays, [ShipDaysBudgetAllocation] )

[smpa01]

@mtb1973  can you provide a bit of context to this

and how [ShipDaysBudgetAllocation] is made of?