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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors