topic Re: Dinamic top N and set the rest into Others group in DAX Commands and Tips

Dinamic top N and set the rest into Others group

Ajeck — Tue, 16 Sep 2025 10:18:37 GMT

Dear Every one,

I need your help,

I want to create a dinamic top N and set the rest into "Othres" .

Here is the PBIX file, what should I do....?

Thank you

Rgds

AjiPBIX file

Re: Dinamic top N and set the rest into Others group

johnt75 — Tue, 16 Sep 2025 12:26:30 GMT

You can use the technique described in https://www.sqlbi.com/articles/filtering-the-top-products-alongside-the-other-products-in-power-bi/

Re: Dinamic top N and set the rest into Others group

FBergamaschi — Tue, 16 Sep 2025 17:52:19 GMT

Hoping to add value to what johnt75 suggested, if you want to be able to select "others" as a filter, this is the improved video

https://www.youtube.com/watch?v=6h9Gmw96xNI

this is not included in the video suggested by johnt75 which shows the basic approach. My suggestion is to what the vidoe he suggested, first, and then the one I suggest here

Best

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: Dinamic top N and set the rest into Others group

Ajeck — Thu, 18 Sep 2025 01:38:30 GMT

Dear FBergamaschi

Tankyou for your sollution, I have watched the video "SQLBI", and i got the sollution,

Thankyou...

Rgds

Aji