Measure with non aggregated String

[Anonymous]

I created a table contain 20  string columns, now I am trying to convert to matrix since I can frezze ID column like Excel. When I put string column in value filed. I have to aggrate the column. It caused some data was mssing. Is it possible to create measure, but doesn't aggreate string to show all info 

ID	Category A	Category B	Category C
1	A	Q	A
1	B	W	S
1	E	E	D
1	D	Y	H
1	N	U	J

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

As @parry2k  said, the prerequisite for the transformation is that there needs to be a column that can be used as a separate identification column, and an index index column can be created in the power query. Then put its field into the column. Refer to the following operation:

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

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

[parry2k]

@Anonymous If you have same id for all the rows, you cannot do anything, you need to have a unique column on the rows, maybe add a index column in the power query and use that on the rows.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.