Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

TopN

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

Microsoft Employee

7 years ago

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