Forum Discussion

abloor's avatar
abloor
Helper IV
6 years ago
Solved

Create a distinct list/table from multiple other tables

Hi,   I need to create a list/tabe of distinct/unique Names, but I need to take the values from a few different tables.   I have done this already in my document from one table with the below mea...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi abloor ,

     

    To fix the error "Circular dependency detected" , you might not use CALCULATE or CALCULATETABLE function in the DAX bridge table.

     

    You can create calculated table like DAX below, then you can filter out the blank value and create relationships as you need.

     

    Table = UNION(DISTINCT('Table 1'[Name]), DISTINCT('Table 2'[Name]),DISTINCT('Table 3'[Name]))

    Best Regards,

    Amy

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi abloor ,

 

To fix the error "Circular dependency detected" , you might not use CALCULATE or CALCULATETABLE function in the DAX bridge table.

 

You can create calculated table like DAX below, then you can filter out the blank value and create relationships as you need.

 

Table = UNION(DISTINCT('Table 1'[Name]), DISTINCT('Table 2'[Name]),DISTINCT('Table 3'[Name]))

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

wesentadesse99's avatar
wesentadesse99
Frequent Visitor
3 years ago

Is it possible to use filter on one of the table to remove some unwanted attributes from the table