topic Re: Many to Many relationship does not work. Not all relations are displayed in DAX Commands and Tips

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

fabre — Wed, 05 Jan 2022 15:48:08 GMT

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.

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

smpa01 — Wed, 05 Jan 2022 15:52:09 GMT

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.

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

VahidDM — Wed, 05 Jan 2022 23:58:55 GMT

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/

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

v-easonf-msft — Fri, 28 Jan 2022 07:56:20 GMT

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

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

fabre — Fri, 28 Jan 2022 08:57:55 GMT

Hey,

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

Don't know why, but now it works.

Best Regards,

Fabian