Forum Discussion
FILTER function with a List as filter condition
Hello everyone! I have a customer who does a lot of different filterings, i.e. for Article groups and subgroups, location groups and subgroups, including changing overlap and changing groups. To ...
Anonymous
Simply
VAR ItemList = VALUES(dimProduct[ItemNumber)
Thank you so much for your help. Keeping it simple, it would be a dimProduct table that is filtered many different ways in i.a. a table visual with filter visuals next to it, so my initial thought would be replacing the List string with
VAR ItemList = CONCATENATEX(dimProduct, dimProduct[ItemNumber], ",")
But as you say, I don't get the right thing out of this. CONCATENATEX isn't the right function. How do I get there, though?
tamerj1
Community Champion
Community ChampionAnonymous
Simply
VAR ItemList = VALUES(dimProduct[ItemNumber)