TopN

[Anonymous]

Good afternoon,
I need to show the top 20 sales. Thanks for the help

[v-jiascu-msft]

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

[LivioLanzo · Accepted solution]

This is how: https://www.youtube.com/watch?v=nmsf7Cbx3JM

[Anonymous]

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