Forum Discussion
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 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!
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.
4 Replies
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.
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.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!
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.
