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])
            )
            )
zenmemo's avatar
zenmemo
Helper I
8 years ago

klammymaster so you created a bridge table (removing the duplicate emails) and still you weren't able to connect to the original tables as one-many relationship?

  • zenmemo's avatar
    zenmemo
    Helper I
    8 years ago

    klammymaster, well if your bridge table is void of dupl or null values, it should work. here's an example.

     

     

     

    • 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])
            )
            )