topic Re: Making an active relationship between two tables where no relationship exists in DAX Commands and Tips

Making an active relationship between two tables where no relationship exists

Alex_Hasan — Wed, 27 Jul 2022 05:45:31 GMT

In this two tables, there is no relationship (Only many to many relatioship can be formed). So, I want to make 1 to many relationship where the factsales will also contain customerkey (Many side) How to write a dax forthis?

Re: Making an active relationship between two tables where no relationship exists

amitchandak — Wed, 27 Jul 2022 15:15:18 GMT

Alex_Hasan , In the customer table, the customer key should be unique and should not have a blank value. then you should be able to create a 1-M join

Re: Making an active relationship between two tables where no relationship exists

Alex_Hasan — Wed, 27 Jul 2022 16:04:28 GMT

Yes, customer key column is unique and does not have a blank value. But how to create a customer key column in factsales table?

Re: Making an active relationship between two tables where no relationship exists

Anonymous — Fri, 29 Jul 2022 09:57:06 GMT

Hi Alex_Hasan,

You should first create relationship between two tables, through the same field:

And then you can make 1 to many relationship based on “Customer Key.

Best regards,

Community Support Team Selina zhu

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

Re: Making an active relationship between two tables where no relationship exists

Alex_Hasan — Mon, 01 Aug 2022 14:19:41 GMT

Hi, those two ETLloadIDs are many to many relationship. what should I do?