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