Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
Use the customer ID from the customer table, not the sales table
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |