Forum Discussion

mcantos's avatar
mcantos
Helper II
1 year ago
Solved

Creating a matrix using measures

Hi community,    I created a similar post some weeks ago, but then I realized it did not work as expected because I didn't create all the measures I needed, so I need your help again. I have these...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mcantos 

     

    Line breaks are implemented by "Enter" inside this double quotation mark (Enter key on the keyboard).

    This is the CONCATENATEX() function's delimiter.

    CONCATENATEX function (DAX) - DAX | Microsoft Learn

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi mcantos 

 

Please try this:

Here's the sample table:

Then add a measure:

MEASURE =
CONCATENATEX (
    'Table',
    'Table'[Opportinity name] & "," & 'Table'[Asset Type] & "," & 'Table'[Mechanisms of action],
    " 
"
)

The result is as follow:

 

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mcantos's avatar
    mcantos
    Helper II
    1 year ago

    Thank you so much Anonymous , that's what I needed!! I did not imagine it could be even easier.

     

    The only problem I have now is I can't make the matrix generate a row per value as you did. For instance, this is what I get:

    The second value for Pre-Due Diligence - Active is appended to the first one instead of creating a new Active row like the one you displayed. 

    Is there any conf on the visual that I am missing? 

    Thank you again!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi mcantos 

       

      Line breaks are implemented by "Enter" inside this double quotation mark (Enter key on the keyboard).

      This is the CONCATENATEX() function's delimiter.

      CONCATENATEX function (DAX) - DAX | Microsoft Learn

       

       

      Best Regards

      Zhengdong Xu
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.