TOPN and CONCATENATEX Help Please for TOP3 ( debug formula)

[luisClive]

Hi I really need some help

im looking for this result ,

..............top 3 Clients concatenated in a row, which all works perfect

HOWEVER when a partner has only top 2 ( i.e has only 2 Clients in porfolio)...

this is what I get .....TOP 2 and all unwanted junk (i.e top2 + all other Clients with no value and no relation to that partner)

Please advise how to debug formula so that if if less than 3 only 2 values or 1 Value is returned ( sort of like ignore blanks too..)

Here is the DAX Code

TOPN CLients =

var topntable =

TOPN(3,ALLSELECTED('FY Revenue YTD and Month Costs and Eng'[Client Name]),[Actual Select],DESC)

RETURN

CONCATENATEX(topntable,'FY Revenue YTD and Month Costs and Eng'[Client Name],",",[Actual Select],DESC)

[lbendlin · Accepted solution]

They all show up because they are tied for third place.

Add a filter to exclude clients without [Actual Select] value.