Forum Discussion

mahawkins3's avatar
mahawkins3
Helper I
8 years ago
Solved

Cannot create relationships - Power BI finding duplicates that do not exist

Hi all,   I am trying to create a relationship between two tables.   Table 1 ('CLTV') contains all transactions, including the User_ID for the customer making each transaction.   Table 2 is a c...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    mahawkins3,

     

    You may use the formula below.

    Table =
FILTER ( DISTINCT ( CLTV[User_ID] ), NOT ( ISBLANK ( CLTV[User_ID] ) ) )
WolfBiber's avatar
WolfBiber
Microsoft Employee
8 years ago

Hey,

look if you have (Null) value and maybe an empty value '' in your table. As far I can remember both are treated equal for an relationship. So you have to filter them out