Show Top, Bottom and Other category

[sumanth1601]

I created below measure, to show top N and others. I was also able to create Bottom N and Others by just changing the order in one of the step. But my goal would be to have say Top 3 and Bottom 3 and club the rest under others. For more details I created this using Youtube video from Goodly - Top Sale for Top Products and others.

Measure created :  Top N SUM Table =

VAR TOPNSelected = SELECTEDVALUE('TopN Selection'[Value])

VAR CurrentProd = SELECTEDVALUE('Pseudo Prod Table'[Product])

VAR TopProducts = TOPN( TopNSelected, ALLSELECTED('Pseudo Prod Table'[Product]), [Total Sales] )

              VAR TopProdSales = CALCULATE( [Total Sales], KEEPFILTERS( TopProducts ) ) RETURN IF( HASONEVALUE('Pseudo Prod Table'[Product]), SWITCH( TRUE(), CurrentProd <> "Others", TopProdSales, CurrentProd = "Others", CALCULATE( [Total Sales], ALLSELECTED('Pseudo Prod Table'[Product]) ) - CALCULATE( [Total Sales], TopProducts ) ), [Total Sales] )

[amitchandak]

@sumanth1601 , refer if this approach can help

Power BI- TOPN with Others- https://youtu.be/I_TY4hVlzAE

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.