measure to concatenate the top ten customer names and their profit to use in a tooltip

[ruthhacche]

I feel like I may be close on this (but am probably a million miles away). I want to create a concatenated text list of the top 10 customer names and their profit to appear in a tooltip.

Top 10 Customers =
var LIST =VALUES(Customer[ACCOUNT Name])
var profit = CALCULATE([SF Profit],ALLSELECTED('Calendar'[FiscalYear]))
var shortlist = topn(10,LIST,profit,DESC)
return
CONCATENATEX(shortlist,[ACCOUNT Name] & FORMAT(profit," £#,##0"),unichar(10) ,[SF Profit],DESC
)

I get all customers (if there is more than 10) and all profit. So in the tip below there were only two customers in that year but it lists all 4 customers from across all years and each one has the total profit for all 4 customers for all 4 years. How do I filter the profit to customers and to fiscal year. It is going to be incredibly excellent when it works!

 

[ruthhacche]

I was closer when I did this but it is doing the list for all fiscal years not just the one selected.

Top 10 Customers1 =
var LIST =VALUES(Customer[ACCOUNT Name])
var shortlist = topn(10,LIST,[SF Profit],DESC)
return
CONCATENATEX(shortlist,[ACCOUNT Name] & FORMAT([SF Profit]," £#,##0"),unichar(10) ,[SF Profit],DESC
)

 

[ruthhacche]

Solved it!

Top 10 Customers1 =
var LIST =VALUES(Customer[ACCOUNT Name])
var shortlist = filter(topn(10,LIST,[SF Profit],DESC),[SF Profit]>0)
return
CONCATENATEX(shortlist,[ACCOUNT Name] & FORMAT([SF Profit]," £#,##0"),unichar(10) ,[SF Profit],DESC
)