Forum Discussion

Karl-D's avatar
Karl-D
Icon for Helper I rankHelper 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] ,",")

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
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] ,",")