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