Visuals taking long time too load and refresh

souvik900766  I have checked your file. Your request is similar to ABC analysis. Because you have too many product IDs(around 25k unique value, your measure calculation takes up a lot of memory, so it will take a long time to refresh.
I have provided 2 kinds of solution :

1st, dynamic measure, I optimized your code. It takes about 32 seconds to query the results, and the FE engine is used, the SE engine has no room for optimization. I think it is not a good solution. Because making users wait so long time after selection is a bad experience.

2nd, Create a calculation table, calculate the results of the cumulated values first. Since the data refresh of the calculation table is done when the data source is refreshed and loaded，so it will save lots of time on the measure calculation. it will also increase the speed of your chart refresh.

Optimize TOP customers.pbix