How to get different columns (fields) from different tables in to TABLE visual

[Anonymous]

Hi,

Today I wanted to bring three columns (fields) from three different tables in to Table Visual but I couldn't.

Three columns are:

1) CustomerName from "Customer" table

2) CustomerId from "Sales" table

3) Exposure from "Exposure" table

I can't understand why i couldn't do that.

1) Please can anyone explain why?

2) What should I do to get Sales table data and Exposure table data together in to TABLE visual, BASICALLY I DO NOT WANT TO USE CUSTOMER TABLE INFORMATION

3) To achieve POINT (2) how my data model should look like

PLEASE NOTE: I DO NOT WANT TO USE MANY-TO-MANY RELATION (BECAUSE TABULAR MODEL DOESNOT ACCEPT)

Here with the example:

Data Model:

Data:

Customer	Sales	Exposure

Thank you

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create the relationship as below

Add columns in the table visual, select "sum" for "sales" and "exposure" column.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jthomson]

Use the customer ID from the customer table, not the sales table