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

2 Replies

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    mtb1973  can you provide a bit of context to this

    and how [ShipDaysBudgetAllocation] is made of?

     

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