Create groups with repeated products and use as slicer

[aicms]

Hi all,

I have a list of products and would like to create two groups, with one of the products (Product A) belonging to both groups, and then create a slicer of the "Groups" and select on Group to analyse at a time.

When I connect it to my dim_Product table, it appears an error mentioning that I cannot have a repeated product in "Products".

How can I make this work?

Table:

Products	Groups
Product A	Group A
Product B	Group A
Product C	Group A
Product A	Group B
Product D	Group B

Thank you!

Adriana

[mahoneypat · Accepted solution]

You should be able to use that table you show as an example directly in your model, and then make a relationship from your Products column to the Product column in the other table(s).  If you make a slicer on the Group column, the Product A will be included in the filter to the related table for both Groups.

Pat

[aicms]

I had that impression but for some reason it didn't work.. but after you mentioned it, I deactivated the automatic relationship between tables and made it manually, so the problem disappeared 🙂

Thank you!!