Many to Many relationship does not work. Not all relations are displayed

[fabre]

Hello, I have the following model:

A customer can be assigned to multiple business units. On the other hand, a business unit can include several customers.

I solve this in the model with a customer table, a business unit table and a bridge table that represents the relationship between customer and business unit and only contains the CustomerKey and BusinessUnitKey. The relationship between the bridge table and the customer table is bi-directional, so that the calculation in the fact table 'orders' also works on the business unit level.

Now it happens that if for example a customer is assigned to two business units and I want to display the relationship plus the order total of this customer in a table or matrix in Power Bi, only one business unit assignment is displayed and not both.
So I want both business units to be indicated with display of the same customer with the same order total, so that order total and e.g. customer number are shown 2 times in the table.

I hope you can help me with this.

[v-easonf-msft]

Hi, @fabre 

Could you please tell me whether your problem has been solved?

If you still need help, please share more information.

Best Regards,
Community Support Team _ Eason

[fabre · Accepted solution]

Hey,

yeah, solved the problem by creating a completely new model.

Don't know why, but now it works.

Best Regards,

Fabian

[VahidDM]

Hi @fabre 

As @smpa01 mentioned Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

[smpa01]

@fabre  provide sample data and expected output. If possible provide a sample pbix by uploading the file in 1/g drive and share the link here.