Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I'm trying to build a table and table visual that will display the total calls for each rep as well as the total calls reviewed for quality. Right now I have two data models linked but can't seem to find a way to get a third table to summarize the 2:
Table on the Left shows total accounts for each rep. Table on the right shows total sampled for each rep.
The table visual I'm building should look like this:
Solved! Go to Solution.
I found a way to get it to work. Wound up creating a concatenated column for the rep name and joining the tables as many-to-one. Thanks for your insights!
I found a way to get it to work. Wound up creating a concatenated column for the rep name and joining the tables as many-to-one. Thanks for your insights!
Possibly, although switching the relationships might cause problems with relating other columns into the new table I'm creating.
| User | Count |
|---|---|
| 50 | |
| 37 | |
| 31 | |
| 22 | |
| 19 |
| User | Count |
|---|---|
| 134 | |
| 102 | |
| 59 | |
| 37 | |
| 36 |