Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Circumwent a circular dependency

Hi people,    I want to create a column where every value just appears one time.  DISTINCT will create a circular dependency.       CONCATENATEX(DISTINCT(FILTER('BaseData','BaseData'[OrderNum...
Need Help
Tips and Tricks
  • v-xicai's avatar
    v-xicai
    5 years ago

    Hi Anonymous ,

     

    You may create  a calculated table first of all, then create a calculated column  [s_t column] in 'Table2' like DAX below.

     

     

    Table:

Table2 = SUMMARIZE(BaseData,BaseData[OrderNumber],BaseData[team], "C_UnderOrderNumber", COUNT(BaseData[OrderNumber] ))



Column:

s_t column = CONCATENATEX(FILTER(Table2,Table2[OrderNumber]=EARLIER(Table2[OrderNumber])),[team]," ")

     

    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
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

You may create  a calculated table first of all, then create a calculated column  [s_t column] in 'Table2' like DAX below.

 

 

Table:

Table2 = SUMMARIZE(BaseData,BaseData[OrderNumber],BaseData[team], "C_UnderOrderNumber", COUNT(BaseData[OrderNumber] ))



Column:

s_t column = CONCATENATEX(FILTER(Table2,Table2[OrderNumber]=EARLIER(Table2[OrderNumber])),[team]," ")

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you a lot v-xicai 😊