https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/concatenating-top-customer-product-names-in-a-measure-output/m-p/958807#M11115 <P>Hi,</P><P>Following up on an earlier thread which was graciously resolved by&nbsp;<A title="" href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/14361" target="_blank">@MFelix</A><SPAN>&nbsp;, I'd like to ask a different question. How does one report the top x number of customer names against a regional sale list. In my case it's about components and products consuming those. The associated model and data is here</SPAN></P><P><A href="https://drive.google.com/file/d/1K5PMiLYH3X5zZBWmb0JikgXEgbptZJZ2/view?usp=drivesdk" target="_blank">https://drive.google.com/file/d/1K5PMiLYH3X5zZBWmb0JikgXEgbptZJZ2/view?usp=drivesdk</A></P><P>&nbsp;</P><P>I'm looking to add a measure that reports the names of the products in the rows for each component indicating the top 2 (or less) products associated with each component's consumption.&nbsp;</P><P><img /></P> Wed, 04 Mar 2020 14:16:20 GMT ali1234 2020-03-04T14:16:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/concatenating-top-customer-product-names-in-a-measure-output/m-p/958807#M11115 <P>Hi,</P><P>Following up on an earlier thread which was graciously resolved by&nbsp;<A title="" href="https://community.powerbi.com/t5/user/viewprofilepage/user-id/14361" target="_blank">@MFelix</A><SPAN>&nbsp;, I'd like to ask a different question. How does one report the top x number of customer names against a regional sale list. In my case it's about components and products consuming those. The associated model and data is here</SPAN></P><P><A href="https://drive.google.com/file/d/1K5PMiLYH3X5zZBWmb0JikgXEgbptZJZ2/view?usp=drivesdk" target="_blank">https://drive.google.com/file/d/1K5PMiLYH3X5zZBWmb0JikgXEgbptZJZ2/view?usp=drivesdk</A></P><P>&nbsp;</P><P>I'm looking to add a measure that reports the names of the products in the rows for each component indicating the top 2 (or less) products associated with each component's consumption.&nbsp;</P><P><img /></P> Wed, 04 Mar 2020 14:16:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/concatenating-top-customer-product-names-in-a-measure-output/m-p/958807#M11115 ali1234 2020-03-04T14:16:20Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/concatenating-top-customer-product-names-in-a-measure-output/m-p/959411#M11159 <P>Found a solution using this tip posted here</P><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Concatenated-list-of-top-items/td-p/237585" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/Concatenated-list-of-top-items/td-p/237585</A></P> Wed, 04 Mar 2020 22:13:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/concatenating-top-customer-product-names-in-a-measure-output/m-p/959411#M11159 ali1234 2020-03-04T22:13:28Z