Power BI Top 5 sales

[Lionel_Charley]

Hi,

I need help with Top 5 sales. My power table looks like the first table. I need to transform the data as the second table that shows top 5 sales and rest is categorised under others

[Lionel_Charley]

Thank you all for the support

[Anand24 · Accepted solution]

Hi @Lionel_Charley ,
Create below 2 calculated columns:

Place Rank = 
RANKX(
    ALL('Sales by Place'[Place]),
    CALCULATE(
            SUM ( 'Sales by Place'[Sales]),
            ALLEXCEPT('Sales by Place', 'Sales by Place'[Place]) 
    )
)

New Place = 
IF(
    'Sales by Place'[Place Rank] >= 1 && 'Sales by Place'[Place Rank] <= 5, 'Sales by Place'[Place],
    "Others"
)

Result:

Let me know if you require the .pbix.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Ahmedx]

you need to watch this
https://www.sqlbi.com/articles/showing-the-top-5-products-and-others-row/