Forum Discussion
Rank X performance with large dataset
Hi all, I have some troubles with the Rankx function with a large dataset ( > 4000 unique articles to be ranked based on sales) I have some filters that will be applied to the whole dashaboard ...
Hi Albertosaravall ,
first, try to debug it.
remove ALLSELECTED ( 'Products' ) and check performance.
In order to find the biggest memory consumer.
then we can try to suggest smth.
I have also found a similar post, please refer to it to see if it helps you.
Top 10 - DAX formula optimization
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.