Power BI Visual for list of concatenated values

[wheelsshark]

Hi,

I have a measure for lookup like 

LookupTown=
VAR _h=[HighestTotal]
RETURN CONCATENATEX(FILTER('tempdumpdata','tempdumpdata'[Total]=_h),'tempdumpdata'[Town],",")

here i get the list of towns like T1,T2,T3,T4....T222

I want to show the values in a visual like a table or someway easy to understand. Can you please help me in achieving it?

[tamerj1 · Accepted solution]

Hi @wheelsshark 

Place the town column in a table visual then place the following measure in the filter pane of the table visual, select "is not blank" then apply the filter

TownFilter =
VAR _h = [HighestTotal]
RETURN
COUNTROWS ( FILTER ( 'tempdumpdata', 'tempdumpdata'[Total] = _h ) )