How to display multiple rows in a single cell of a matrix or table – CONCATENATEX Tutorial

How can I condense multiple rows into a single cell in a matrix or table?
Obviously it's easy to view all the details, but what if I just want to see a list of countries, channels, etc.? in which my product sells without displaying all permutations of these data elements?

It turns out we have to write a bit of DAX but luckily not much at all using one of my favorite functions CONCATINATEX()

#powerbi #mspowerbi #knowledgebank #tutorial #data

Link to blog and template: https://businessintelligist.com/2021/10/20/how-to-display-multiple-rows-in-a-single-cell-of-a-matrix-or-a- table /

Please take the opportunity to connect and share this video with your friends and family if you find it useful.