Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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).
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.
@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).
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
19 | |
15 |