Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
cdawidow
Helper III
Helper III

Unable to Connect a unique column to sales data!

 Problem1.PNG

 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?

1 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).

View solution in original post

3 REPLIES 3
nandic
Memorable Member
Memorable Member

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

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.

 

 

help.PNG

 

@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).

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors