Need Assistance Optimizing DAX Statement

[Anonymous]

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

[Greg_Deckler]

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)