Forum Discussion
Solved
Lookupvalue using Search\ContainsString?
Hi Experts, could you please help in finding the solution for my requirement I have 2 tables with 40K rows in each table, I have slicer with package column from Table A and i have a table visual...
smoka3 , Create a new column in TableB
maxx(filter(TableA, CONTAINSSTRING(TableB[Command], TableA[Package])),TableA[Package])
Greg_Deckler
Community Champion
Community Championsmoka3 - So basically this is a Complex Selector - https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534.
Kind of.
In your case, something like this:
Measure =
VAR __Command = MAX('Table B'[Command])
VAR __Table = ADDCOLUMNS(ALL('Table A'),"Include",FIND([Package],__Command,,0))
RETURN
MAXX(FILTER(__Table,[Include]>0),[Package])
Package... LOL...
Thank you!
