Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm having what I think is a simple problem and can't seem to find a solution. I have two Excel datasets which contain marketing lead data and built them out into a matrix in PowerBI. Each table has an "Asset/Activity" field, and I want to create a slicer which will filter both sets of data. When I try to build a relationship between the two tables on the aformentioned field, I get an error: "You can't create a relationship between these two columns because one of the columns must have unique values"
Any help is appreciated!
Solved! Go to Solution.
You will need to create a lookup table with distinct values to join the fact tables. Then use the lookup table to populate your slicers. It is not difficult and can be completed using the built in query editor. Check this link for more information.
Proud to be a Super User!
You will need to create a lookup table with distinct values to join the fact tables. Then use the lookup table to populate your slicers. It is not difficult and can be completed using the built in query editor. Check this link for more information.
Proud to be a Super User!
You might also be able to create the lookup table using a calculated table and the SUMMARIZE function.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |