Forum Discussion

WinterMist's avatar
WinterMist
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

DAX Comma Separated Product Values Within Table Visual

Hello Community -    The test PBIX is located here: https://drive.google.com/file/d/1FoKbRlzzW378owG71w_qwDVfkxCwLP9x/view?usp=sharing     The following table visual exists, with 4 rows for 202...
  • sevenhills's avatar
    sevenhills
    2 years ago

    Try this:

     

     

    List of Product Names = 
CALCULATE(  CONCATENATEX( filter( all('Product'), 'Product'[ProductKey] in VALUES('Fact Sales'[ProductKey])), 'Product'[Product Name], ", ", 'Product'[Product Name], asc))

     

     

     

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
2 years ago
Concat = 
CONCATENATEX(
    CALCULATETABLE( VALUES( 'Product'[Product Name] ), 'Fact Sales' ),
    'Product'[Product Name],
    ", "
)