Forum Discussion
Comma separated list
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 th...
Anonymous
maybe you can try this
Measure = CONCATENATEX(values('Table'[farbric code]), 'Table'[farbric code],",")I missed this reply.
maybe you can try to change to ISFILTERED('Table'[month])
changed the doc column to month column
Anonymous
still can't reproduce the issue.
is it possbile to share the pbix file after removing sensitive data?
do you have a way to not have to show its total on the report table?
turn off the total
or
update the DAX
Measure = if(ISFILTERED('Table'[DOC]), CONCATENATEX(VALUES('Table'[farbic code]),'Table'[farbic code],","))wow, I'll use the 2nd method... because I also need to show total of some other columns.
you are really cool
thank you!!!
you are welcome
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],","))I missed this reply.
maybe you can try to change to ISFILTERED('Table'[month])
changed the doc column to month column