Forum Discussion

mahawkins3's avatar
mahawkins3
Icon for Helper I rankHelper 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] ) ) )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

mahawkins3,

 

You may use the formula below.

Table =
FILTER ( DISTINCT ( CLTV[User_ID] ), NOT ( ISBLANK ( CLTV[User_ID] ) ) )
  • mahawkins3's avatar
    mahawkins3
    Icon for Helper I rankHelper I
    8 years ago

    Thanks for the replies - both are correct; accepted v-chuncz-msft as it's a more direct solution.