Group display values

[Ion_Gomez]

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

[Anonymous · Accepted solution]

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,
Kelly

Did I answer your question? Mark my post as a solution!

[Syndicate_Admin]

Buenas Kelly,

I got what I wanted, the problem now is that it is repeated. it comes out this way..

[Syndicate_Admin]

Hello kelly couldo you please resende the pbx?

Thank you

[amitchandak]

@Ion_Gomez , you need to use concatenatex

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

new measure = (Table,Table[cadigo pedio])

[harshnathani]

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!