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])
            )
            )
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI klammymaster

Are you expecting the email addresses to be unique in one of the files?  Or can the same email naturally occur more than once in the tables?

klammymaster's avatar
klammymaster
Frequent Visitor
8 years ago

Hi Phil_Seamark,

 

The same emails will occur more than once in the smaller file. The smaller file contains eletronic device assignments and 1 user can have multiple devices. The bigger file is a gigantic list with all users. Please let me know if I can give you more detail.

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi klammymaster

     

    WHat is the name of your two tables, including the names of the columns that have the email addreses?

     

    I can give you a formular for a calculated table that you can use as a slicer.

    • klammymaster's avatar
      klammymaster
      Frequent Visitor
      8 years ago

      Hi Phil_Seamark,

       

      Table 1 is "biibuserdata" with the column name "biibEmail". Table 2 is "Intune" with the column name "Email address".