topic Re: Top 15 records and to show others as one group in table chart in DAX Commands and Tips

Top 15 records and to show others as one group in table chart

Anonymous — Fri, 03 Feb 2023 14:37:12 GMT

Hi,

I have requirement to show top 15 records and rest all other records to Show as Others,
I have one Employee ID's column and one calculated colum- Total Efforts spent

I have to show top 15 Employees with total efforts spent and rest all Other employees to show as "Others" in Table Chart.

Any help?

Thanks
Likhitha

Thanks

Re: Top 15 records and to show others as one group in table chart

AlB — Fri, 03 Feb 2023 15:27:38 GMT

Hi Anonymous

Can you provides some sample data?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Re: Top 15 records and to show others as one group in table chart

Anonymous — Mon, 06 Feb 2023 05:11:15 GMT

Hi Anonymous

You can refer to the following example

create a new column in the table

Type = var _top15=SUMMARIZE(TOPN(15,'Table',[Total],DESC),[ID]) return IF([ID] in _top15,FORMAT([ID],""),"Ohter")

Then put the column to the table visual, and create a new measure in the table

Measure 2 = SUM('Table'[Total])

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.