Forum Discussion
TopN
Good afternoon,
I need to show the top 20 sales. Thanks for the help
3 Replies
Thanks LivioLanzo for the collaboration. Try to download this version of power BI because it is supposed to come with the TopN but it does not give me:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/preview/#topN
Hi Anonymous,
Does this topic try to solve the same problem?
You also can create a measure with the function RANKX. Something like below.
rank = RANKX ( ALL ( DimProduct[ColorName] ), CALCULATE ( SUM ( FactSales[SalesQuantity] ) ) )Best Regards,
Dale
