Forum Discussion
Resolver IAdd Customer's Name as a column in a Matrix
Hello,
I have a Matrix where the row is Contract Nr., and I would like to add the Customer's Name (coming from another related table) to the Matrix as "Values"
How can this be achieved, please?
Best regards,
Simon
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/glxnG
11 Replies
v-zhangtiCommunity Support
Hi, y5famfnatudu
Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Ashish_Mathur
Super User
Hi,
As long as the 2 tables are relatd, you should get the expected result when you drag Customer name to the row itself (not values) of a matrix visual.
y5famfnatuduWith a table that shouldn't be a problem, but with Matrix that won't work, a measure is needed to get the related customer(s).
Best regards,
Simon
- Ashish_Mathur
Hi,
Share some data to work with and show the expected result.
- y5famfnatudu
The Model is very simple, as shown in the screenshot below
Here's what I'm trying to achieve:
Kindly note that I'm not allowed creating any calculated tables, nor calculated columns.
Best regards,
Simon
- Ashish_Mathur
Drag Customer from Table2 and write this measure
Total = sumx(Table1,Table1[Amount]*Table1[Quantity])
Hope this helps.
- y5famfnatudu
Kindly note that dragging customers to values won't won't work.
My concern is not the Sales amount, rather the customers.
Best regards,
Simon
- Ahmedx
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/glxnG- y5famfnatudu
Perfect, thank you so much Ahmedx
