Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
@Alta88 , can you make the join one to many, treat one of the tables as master, and then check
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |