Forum Discussion
Solved
Filter a table based on concatenated values
Hi guys, I am working with a table in which the products are concatenated in the same column instead of having one row per product row : REF PRODUCT OFFERED 001 AAA BBB DDD 002 C...
DIACHROMA OK, try this as the RETURN then:
COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__AllRefsTable,[__Ref]<>BLANK()),"__Ref",[__Ref])))
DIACHROMA OK, try this as the RETURN then:
COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(__AllRefsTable,[__Ref]<>BLANK()),"__Ref",[__Ref])))
It works !!!!!! 😊
A big thank you Greg_Deckler , you can't imagine how much you helped me today (tonight for me)!
Thank you again and have a great weekend !!!
Pauline
DIACHROMA Greg_Deckler Could someone please share sample .pbix for working solution