Creating a matrix using measures

[mcantos]

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 fields coming from the same table:

I need to create a report like this where each cell is the result of getting the opportunity name, Asset type, and Mechanism of Action for each combination of Stages and Status:

Someone in the previous post, suggested creating measures and using a matrix as a visual which I did.

Sample of the the measure for cell 1 (yellow color):

The problem is when I create the matrix, I don't get the table organized as expected (above) and all the values come in one row instead of one row per record:

These are the visual conf. The values are the measures I created. I set the measures as values and the Status as rows

What am I doing wrong? I don't know how to set the measures to get the specific order. 

Thank you!

[Anonymous]

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]

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 · Accepted solution]

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.

[Selva-Salimi]

Hi @mcantos 

the easiest way that I recommend is to use cards and text boxes and arrange them near each other so that end user think that it was a matrix! please let me know if you have any challenge in using cards!

If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly.