Unable to Connect a unique column to sales data!

[cdawidow]

 

 Hi guys, new to power bi but I am having trouble filtering my sales data with my contract data.  I want to break up my contract name sales based on product line and prod no but every calculation I get is wrong.  Any suggestions?

[nandic]

Hi @cdawidow ,

Could you share some screenshots, at which level (relationship, measure) do you get errors?
What is relationship between these two tables? If relationship is based on multiple columns, you should make composite key (concatenate multiple columns in one column on both tables) and make join using this composite key.

If neither of these two tables have unique composite key then you should create third table which will have unique key so that you can make join between tables.

Cheers,
Nemanja

[cdawidow]

Hey!  thanks for your response, I made some modifications but still, it is not working.  I tried to create a one to many relationship but for romse reason power bi will not allow me to do so.

[nandic · Accepted solution]

@cdawidow ,
First step, add new columns in all these 3 tables: Contracts, Product Header, Sales (2).
This new column formula: prod line & " " & prod No
Then you create join between these tables based on that new column and make sure this relationship is active.
Note: make sure when you check data that table Product Header has distinct values (no duplicates).