Comma separated list

[Anonymous]

Hi all,

I am having trouble processing data in power BI. 

Can you help me make all of FABRIC CODE each OUT DOCUMENT become a row (the fabric code a comma separated list).

I am very grateful for this.

Thank you!!!

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try this

Measure = CONCATENATEX(values('Table'[farbric code]), 'Table'[farbric code],",")

[Anonymous]

My data source same this

[ryan_mayu · Accepted solution]

@Anonymous 

maybe you can try this

Measure = CONCATENATEX(values('Table'[farbric code]), 'Table'[farbric code],",")

[Anonymous]

Yes, thank you!

I have done it before. However, my source data contained a lot of rows... and they outputted everything.

Do you have any other way?

[ryan_mayu]

do you mean duplicated fabric code?

i tried to reproduce the situation, the measure does not combine the repeate fabric code.

could you pls provide the sample data?

[Anonymous]

Oh Yes I made it... Woww... thank you, thank you so much 😘

[ryan_mayu]

you are welcome

[Anonymous]

Wow, that is result of your formula... only it doesn't follow OUT DOCUMENT

[ryan_mayu]

you need to remove the " farbric doe customer " column

[Anonymous]

the same this... 

Data row is very large. Looks like I need to filter them before using CONCATENATEX... but I don't know how to make

[ryan_mayu]

@Anonymous 

still can't reproduce the issue.

is it possbile to share the pbix file after removing sensitive data?

[Anonymous]

do you have a way to not have to show its total on the report table?

[ryan_mayu]

 turn off the total

or 

update the DAX

Measure = if(ISFILTERED('Table'[DOC]), CONCATENATEX(VALUES('Table'[farbic code]),'Table'[farbic code],","))

[Anonymous]

I don't know why I use this formula it's not run

Measure = if(ISFILTERED('Table'[DOC]), CONCATENATEX(VALUES('Table'[farbic code]),'Table'[farbic code],","))

[ryan_mayu]

you can also try this

Measure = if(HASONEVALUE('Table'[doc]),CONCATENATEX(VALUES('Table'[fabric code]),'Table'[fabric code],","))

[ryan_mayu · Accepted solution]

I missed this reply.

maybe you can try to change to ISFILTERED('Table'[month])

changed the doc column to month column

[Anonymous]

It's okay... thank you so much!!!

[ryan_mayu]

you are welcome

[Anonymous]

wow, I'll use the 2nd method... because I also need to show total of some other columns.

you are really cool

thank you!!!

[ryan_mayu]

you are welcome