Forum Discussion
Group display values
Hello everyone
I would like to know if it is possible to add the values of the columa that says "Order Code" on a single line. Attached image
This is how the matrix display comes out when I add the order code column. I'd like you to come out this other way.
I do not know if with concatenatex or there is some dax function in which you can put it as in the imagne and so instead of appearing several lines per project that appears only one row.
The data is in different but related columns.
Thank you
Hi Ion_Gomez ,
Create an index column in power query and a calculated column as below:
_Order number = var _index=MAXX(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[Order number]<>BLANK()),'Table'[Index]) Return IF('Table'[Order number]=BLANK(),CALCULATE(MAX('Table'[Order number]),FILTER('Table','Table'[Index]=_index)),'Table'[Order number])Then create a measure as below:
Measure = CONCATENATEX(FILTER(ALL('Table'),'Table'[_Order number]=MAX('Table'[_Order number])),'Table'[Order code],"-")And you will see:
For the related .pbix file,pls click here.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
5 Replies
Hi Ion_Gomez ,
you can try this this measure
Concat = CONCATENATEX ( FILTER ( ALL ( 'Table'[Codigo Proyecto], 'Table'[Codigo Pedio] ), 'Table'[Codigo Proyecto] = MAX ( 'Table'[Codigo Proyecto] ) ), CALCULATE ( MAX ( 'Table'[Codigo Pedio] ) ), UNICHAR ( 10 ) )
Regards,Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)Did I answer your question? Mark my post as a solution!
Ion_Gomez , you need to use concatenatex
https://docs.microsoft.com/en-us/dax/concatenatex-function-dax
new measure = (Table,Table[cadigo pedio])
Hi Ion_Gomez ,
Create an index column in power query and a calculated column as below:
_Order number = var _index=MAXX(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[Order number]<>BLANK()),'Table'[Index]) Return IF('Table'[Order number]=BLANK(),CALCULATE(MAX('Table'[Order number]),FILTER('Table','Table'[Index]=_index)),'Table'[Order number])Then create a measure as below:
Measure = CONCATENATEX(FILTER(ALL('Table'),'Table'[_Order number]=MAX('Table'[_Order number])),'Table'[Order code],"-")And you will see:
For the related .pbix file,pls click here.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!Hello kelly couldo you please resende the pbx?
Thank you
Buenas Kelly,
I got what I wanted, the problem now is that it is repeated. it comes out this way..
