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
Microsoft 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".