Matrix with Text Column in the Values

[natasha_antosha]

Hi, 

I need to put the text column to the Values section in the matrix visual so that the First aggregation will be used like in the picture. This is the picture from the other person's report, but no matter how I tried Power BI doesn't let me put my text column in the values section. How can I achieve this? 

[Ritaf1983 · Accepted solution]

Hi @natasha_antosha 
You can create a measure with some kind of aggregation on desired column.

For example:

myText = max('table'[needed column]

If it won't work, 

please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly