Forum Discussion
Solved
PowerBI Rankx very slow
Hey guys, I have performance issues with the Rankx function. Currently, i use the rankx function for a dynamic top n selection for a matrix with a slicer. This works fine for a table with less t...
Hi schaetzles ,
If the customer table only has the customername column.
new table = distinct(cusotmer[customername ])If not, it is recommended to create a new table with only customername column, then link the new table with the customer table, and replace the customer table in your formula with the new table.
Rank__Customer = RANKX(ALL(new table[CustomerName] ),[TotalSales])Best Regards,
Jay
Hi schaetzles ,
If the customer table only has the customername column.
new table = distinct(cusotmer[customername ])
If not, it is recommended to create a new table with only customername column, then link the new table with the customer table, and replace the customer table in your formula with the new table.
Rank__Customer = RANKX(ALL(new table[CustomerName] ),[TotalSales])
Best Regards,
Jay