Forum Discussion

mtb1973's avatar
mtb1973
Frequent Visitor
4 years ago

Dax Query Slow - Need ideas to Optimize

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 w...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

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] )