Forum Discussion
Slow Running Dax Measure
Is someone able to tell me why the below dax measure runs painfully slow? I'm trying to identify the customers (identifier being the BasketID in the sales table) who only purchased 1 product: Slow...
Hi Anonymous ,
How about create or var a calculated table and filter the calculated table instead like:
Transactions (Selected Product) Bought 1 Unit = var tmptable = SUMMARIZE( Sales, Sales[BasketID], "Total Units Purchased", [Units Sold (Selected Product)] ) return CALCULATE( [Transactions (Selected Product)], FILTER( tmptable, [Total Units Purchased] = 1 ) )Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
How about create or var a calculated table and filter the calculated table instead like:
Transactions (Selected Product) Bought 1 Unit =
var tmptable =
SUMMARIZE(
Sales,
Sales[BasketID],
"Total Units Purchased",
[Units Sold (Selected Product)]
)
return
CALCULATE(
[Transactions (Selected Product)],
FILTER(
tmptable,
[Total Units Purchased] = 1
)
)
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much! this worked perfectly!