Add Customer's Name as a column in a Matrix

[y5famfnatudu]

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

[y5famfnatudu]

@v-zhangti , @Ashish_Mathur 

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

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/glxnG

[y5famfnatudu]

Hello @Ahmedx ,

If the column I would like to concatenate is part of the Fact Table, how should the measure look like?

I appreciate your help so much.

Best regards,

Simon

[Ahmedx]

maybe like this:

Name Customer = CONCATENATEX('Fact',[Name],", ")

[y5famfnatudu]

Perfect, thank you so much @Ahmedx 

[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

[Ashish_Mathur]

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.

[y5famfnatudu]

Hi @Ashish_Mathur 

With 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.

[v-zhangti]

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.