Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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'[OrderNumber]=EARLIER('BaseData'[OrderNumber]))),'BaseData'[Team]," ")

 

 

A sample file is here: sample.pbix 

 

I want that every value in the "s_t column" just appears one time.

 

For example in the first row: there should be just one "A" in the s_t column.

or in the row where the "UnderOrderNumber" is "4", the row in the s_t colum should be "B C D"

 

Thanks in advance for any help!

1 ACCEPTED SOLUTION
v-xicai
Community Support
Community Support

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

 

206.png

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.

View solution in original post

4 REPLIES 4
v-xicai
Community Support
Community Support

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

 

206.png

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
Not applicable

Thank you a lot @v-xicai 😊

amitchandak
Super User
Super User

@Anonymous , The link is not working

Anonymous
Not applicable

Oh, my bad @amitchandak 

 

sample.pbix 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.