Forum Discussion
DAX function
if the lookup value is duplicated, lookupvalue will get a error.
LookupTown=VAR _h=[HighestTotal] RETURN CONCATENATEX(FILTER('tempdumpdata','tempdumpdata'[Total]=_h),'tempdumpdata'[Town],",")
HI wheelsshark,
Perhaps you can add a new condition to compare with the name field and selection to filter the result.
LookupTown = VAR _h = [HighestTotal] VAR selection = VALUES ( Table[Name] ) RETURN CONCATENATEX ( FILTER ( 'tempdumpdata', 'tempdumpdata'[Total] = _h && [Name] IN selection ), 'tempdumpdata'[Town], "," )Regards,
Xiaoxin Sheng
Thank you Daniel, it works. But I cant understand.
Highest Total is 200 for C1, while var _h is 200
Return concatenatex(filter('tempdumpdata', 'tempdumpdata'[Total] = 200), 'tempdumpdata[Town] - this gives T3 and T2. I need only T3.
bz the slicer selection is C1. Can you help me understand
HI wheelsshark,
Perhaps you can add a new condition to compare with the name field and selection to filter the result.
LookupTown =
VAR _h = [HighestTotal]
VAR selection =
VALUES ( Table[Name] )
RETURN
CONCATENATEX (
FILTER ( 'tempdumpdata', 'tempdumpdata'[Total] = _h && [Name] IN selection ),
'tempdumpdata'[Town],
","
)Regards,
Xiaoxin Sheng