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

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
I have to ask, why do you want to view the data in a concatenated form? From a data modeling and visualization viewpoint it is counterintuitive, unless I'm missing something
sarahhp's avatar
sarahhp
Frequent Visitor
9 years ago

dkay84_PowerBIJust need a simple table view to share info with another internal team.

  • 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