Forum Discussion

mcantos's avatar
mcantos
Icon for Helper II rankHelper 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.

mcantos's avatar
mcantos
Icon for Helper II rankHelper 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.