Query Plan become slower when applying Visual level filter

Hi tomtang ,

From my test, replacing [Sales Amount] with [SalesAmount] field in the original table could slightly reduce the query time.

In addition, you could try to use OPTIMIZEDAX() function

Hope these help.

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

https://docs.microsoft.com/en-us/learn/modules/optimize-model-power-bi/

https://maqsoftware.com/expertise/powerbi/dax-best-practices

https://powerpivotpro.com/2019/03/dax-optimizations-write-it-like-the-dax-calls-it/

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.