Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

non-strict filtering

Hello,  I work with products. Each product can be in many colors. I have two tables: product and product_color.  - The product table contains unique products.  - The product_color table contains ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , try like


calculate(concatenatex(filter(productcolor , productcolor[product] in _prd),productcolor[color]),removefilters(productcolor[color]))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , if the above does not work, Then you have consider independent color table