Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Select first item from filtered rows

I have a measure which return for me first item from filtered row   _FirstFromSelected = VAR _Filtereditems = CONCATENATEX(ALLSELECTED(_tbl),_tbl[Company_Name],"|") RETURN IF(PATHCONTAINS(_Fil...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
5 years ago

You get extra points for using PATHITEM creatively, but what's wrong with TOPN(,1)  ?

Analitika's avatar
Analitika
Post Prodigy
5 years ago

lbendlin wrong is that it is not working as return all values instead only One scalar