Forum Discussion
Solved
Relationship and Unique Values
Hi there, I have a 2 files with many entries trying to relate them together via email addresses. When I try relating the 2 together, I get an error "You can't create a relationship between these ...
Hi klammymaster
Here is a DAX Soluction for creating a slicer table that will have unique values that you can create relationships too.
Then use the field in this table for your slicers
Slicer Table = DISTINCT( UNION ( ALL('biibuserdata'[biibEmail]) , ALL(Intune[Email address]) ) )
Hi Phil_Seamark,
Where do I put the DAX formula? I tried creating a new measure and column and that didn't work. I also tried to create a Slicer Table but I'm not sure where to put the formula.
HI zenmemo
On the Modeling Tab of Power BI Desktop, you should see a New Table button. Click this and paste my code into the formula bar
This should create a table that will be visible in the Relationship View where you can create relationships to it from your existing tables.