Forum Discussion
Need Assistance Optimizing DAX Statement
The below DAX statement is extremely slow (and sometimes exceeds resource limits), and I'm not sure how to optimize its speed. Does anyone have any tips on how this could be written more effeciently?
Total Customers by ATV Bin =
Var MinValue = MAX( 'ATV BinSelect'[MinValueRange] )
Var MaxValue = MAX( 'ATV BinSelect'[MaxValueRange] )
RETURN
CALCULATE(
[Transactions (Selected Product)],
FILTER(
VALUES( Sales[BasketID] ),
[ATV (Selected Product)] >= MinValue && [ATV (Selected Product)] < MaxValue ) )
1 Reply
- Greg_Deckler
Community Champion
I have a whole blog series on performance tuning DAX: https://community.powerbi.com/t5/Community-Blog/Performance-Tuning-DAX-Part-1/ba-p/976275
You probably don't need the VALUES statement so ditch it because it is costing you performance. Otherwise, probably need to understand what that measure is doing (it's formula)
