Forum Discussion
Guille2711410
Helper I
Helper ITop 10
Hello I would like to get the top 10 of my collected commissions, but I also want to prevent the number 1 from appearing, since it is not identified. The formula I use is: M_Top10 = VAR ComP...
mahoneypat
Microsoft Employee
Microsoft EmployeeThis is an expression that returns a 10-row table, so it will error in a measure expression. To get the list of your Top 10, you can use CONCATENATEX, but I am not sure if that is what you need. You can change the Return in your expression to the following.
Return CONCATENATEX(SumFiltered, COMT04 [C76CODCOM])
If you want to omit the top 1, you can do a TOPN(9, SumFiltered, [TotCom], ASC), and then do CONCATENATEX on that table.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat