Forum Discussion

sarahhp's avatar
sarahhp
Frequent Visitor
9 years ago
Solved

Concatenate rows with filter

I don't come from a coding background but I'm trying to take a list of products associated with different companies and concatenate the products associated with each company into a single field.  My ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    sarahhp

     

    Please use a Measure not a column

     

    Look at this:

     

    Product List is a Measure

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

Product List= CONCATENATEX(Table, Table[Product Name],",")

sarahhp's avatar
sarahhp
Frequent Visitor
9 years ago

Vvelarde That fixed the error but now the results being returned are all products for all the Companies when I create a simple table showing Company and Product List.  So I need one further measure that asks Power BI to look at each company, apply the Product List measure and return the results?

 

Company    Product List

Microsoft     SQL Server, Crystal Ball, Oracle VM, etc

Oracle          SQL Server, Crystal Ball, Oracle VM, etc

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    sarahhp

     

    Please use a Measure not a column

     

    Look at this:

     

    Product List is a Measure

    • sarahhp's avatar
      sarahhp
      Frequent Visitor
      9 years ago

      Vvelarde Thanks for the demo - I was using the measure vs column, my mistake was selecting the wrong visualization - doh!  Thanks again!

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago
    Why not just use the matrix visual?

    If possible, I would just use the query editor to pivot the data and then merge the product columns