Forum Discussion

klammymaster's avatar
klammymaster
Frequent Visitor
8 years ago
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 ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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])
            )
            )
klammymaster's avatar
klammymaster
Frequent Visitor
8 years ago

Hi zenmemo,

 

Yes that's exactly what I'm trying to do but I'm not sure why it's not working. Attached are the steps I've done to remove the blanks, errors, null, and etc.

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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])
            )
            )
  • klammymaster's avatar
    klammymaster
    Frequent Visitor
    8 years ago

    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. 

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      8 years ago

      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.

      • klammymaster's avatar
        klammymaster
        Frequent Visitor
        8 years ago

        Hi Phil_Seamark,

         

        You're amazing. Thank you so much for your help :) Appreciate it a lot.