Forum Discussion

brief001's avatar
brief001
Icon for Helper II rankHelper II
4 years ago
Solved

Translate values from rows into a single record value

I have the left table below. And I'm looking for how I can make the right table via a calculated table. In which I am mainly looking for how the values of several rows are 'knotted' together and shown as a summary value. (I am referring to column 'Activity')

  • amitchandak's avatar
    amitchandak
    4 years ago

    brief001 , Create a measure using concatenatex

    concatenatex(table, table[Activity])

     

    and use it with order_id

  • brief001's avatar
    brief001
    4 years ago

    Thank you!! Solved with:

    Tabel_New = SUMMARIZE(Tabel, 
        Tabel[Order_ID] ,
        "Activity_Summary" , concatenatex(Tabel, Tabel[Activity]) ,
        "Duration_Total" , SUM(Tabel[Duration] ))

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    brief001 , Create a measure using concatenatex

    concatenatex(table, table[Activity])

     

    and use it with order_id

    • brief001's avatar
      brief001
      Icon for Helper II rankHelper II
      4 years ago

      Thank you!! Solved with:

      Tabel_New = SUMMARIZE(Tabel, 
          Tabel[Order_ID] ,
          "Activity_Summary" , concatenatex(Tabel, Tabel[Activity]) ,
          "Duration_Total" , SUM(Tabel[Duration] ))

       

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    brief001  you can us ethe following two measures

    Activity_Summary= CONCATENATEX(VALUES('Table'[Activity]),'Table'[Activity],"",'Table'[Activity],ASC)

Duration_Total= CALCULATE(SUM('Table'[Duration]),ALLEXCEPT('Table','Table'[Order_ID]))