Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables joined together on 3 columns
1. Market
2. WeekNumber
3. Division
Using the columns from one table only, I'd like to filter the data for a metric in the other table. However, when I apply the filter, the metric doesn't change. I realised that the data only chages for the column where I've marked the join as "make this relationship active", but i can only do this for one column.
How can I filter the metrics based on all 3 columns of the other table?
Thanks
Solved! Go to Solution.
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604
Hi @v-chuncz-msft , thanks for the link.
I actually ended up doing something similar by merging the columns I wanted to join and then join the tables on these merged columns.
@bo_afk ,
I think you want to join on more than one column. Create a concateneated column in both tables like this
key = Market & "-" & WeekNumber &"-"& Division
and join.
Power BI mutiple joins are there to change relation using userelation. You can check my HR Anaytics blog for that. Link is in signature.
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/composite-primary-key/td-p/307604
Hi @v-chuncz-msft , thanks for the link.
I actually ended up doing something similar by merging the columns I wanted to join and then join the tables on these merged columns.
Hello @bo_afk ,
You need to create measures by using dax : USERELATIONSHIP
This will help you to filter your visuals accordingly.
If you could share the sample data along with expected results, then we could provide a better solution.
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Is it possible for you to share the sample data file? It will help in creating specific solution in this context
Cheers!
Vivek
https://www.vivran.in/
Connect on LinkedIn
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |