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 ...
Hello,
Thank you for your support.
I have tried to remove ALLSELECTED but the performance are not improving. ( the rank anyway is not working in this way, I'm getting 1 for each product). I have some slicer with filters applied to this table that cannot be removed
Just to give you a bit more of context:
- I have around 5k of different product to be ranked based on sales
- I have two different tables, one for the products and one for the sales that are linked with a Many to one cardinality with both filter directions
Thank you!😀