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

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
Community 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!