Forum Discussion
Solved
cister
hello. i have a question i have the fiel "branch Offices" and the measure "Sales",
I need to see the top 10 branch Offices; and rest see it as "Other" in which should be the sum of all the rest of the branch Offices
Hey rcister ,
you can do that with DAX.
Check the following tutorial, that's exactly what you are asking for:
Power BI TopN and Other (proserveit.com)
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
1 Reply
Hey rcister ,
you can do that with DAX.
Check the following tutorial, that's exactly what you are asking for:
Power BI TopN and Other (proserveit.com)
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic