Forum Discussion
TOPN and CONCATENATEX Help Please for TOP3 ( debug formula)
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)
They all show up because they are tied for third place.
Add a filter to exclude clients without [Actual Select] value.
1 Reply
They all show up because they are tied for third place.
Add a filter to exclude clients without [Actual Select] value.