Relationship filters - how to not filter?

[Fleurdc]

Hi all!

Small question: When I create a relationship between the products listed in dataset A and B (many to many and bi-diretional) with A having more products in it then B, only the matching products between A and B will be shown. Why does the relationship filters A's dataset? And can I overcome this problem?

Thank you so much in advance!

Kind regards,

Fleur de Clercq

[v-tianyich-msft · Accepted solution]

Hi @Fleurdc ,

You can try using single cross filter direction, or use measure:

Measure = var _select = VALUES('Table'[Category])
RETURN COUNTAX('Table',[Category] in _select)

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amustafa]

It depends which table you are pulling the column(s) from. Best to go back in Power Query and merge or append both tables to get a single table.

[Fleurdc]

Thank you Amustafa for your answer! Though, list B consists of a list of categories and then of which products the categories consist of. I want to be able to select a category and then display the corresponding products. The problem here is: when I want to make one list of A and B by appending or merging, some products will be in more than one category, which makes appending or merging difficult (it will result in more than one column (a seperate one for every category) added per product. Then, when I want to choose the category in my graph, it does not work or it does not recognize it.

Do you have a solution for that by any chance?

[amustafa]

Can you privide a sample data and expected outcome?

Please refer to this post: How to Get Your Question Answered Quickly - Microsoft Fabric Community