Forum Discussion

Karl-D's avatar
Karl-D
Helper I
3 years ago
Solved

Build Order Summary using CONCATENATEX?

I have an "Orders" table which shows order lines.  I do not have an Order Header table.   Each [OrderNumber] may have multiple rows in the "Orders" table, representing different items from differe...
  • amitchandak's avatar
    amitchandak
    3 years ago

    Karl-D , if tables are already joined , try like

     

    DeptListMeasure = CONCATENATEX(values('Department'),'Department'[DepartmentDesc],",")

     

    or like

     

    DeptListMeasure = CONCATENATEX( Summarize('Orders','Department'[DepartmentDesc]),[DepartmentDesc] ,",")

     

     

Karl-D's avatar
Karl-D
Helper I
3 years ago

amitchandak to the rescue again!  Thanks so much.  The second one with the Summarize is what I needed.

DeptListMeasure = CONCATENATEX( Summarize('Orders','Department'[DepartmentDesc]),[DepartmentDesc] ,",")