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! Get ahead of the game and start preparing now! Learn more
I have this DAX formula that works fine but I was wondering if it can be adjusted so it includes a second table. My model had table # 1 (historical data) and table #2 (current date). Each of these tables has exactly the same structures and I am trying to create a virtual table that would count the number of callers and display the caller name beside the count. My formula works fine if I am considering only table #1 but is there a way to include table #2 into this?
Callers Summary =
SUMMARIZECOLUMNS (
'Table #1' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
)
Solved! Go to Solution.
i was able to do this which worked for me
Combined Callers Summary =
UNION(
SUMMARIZECOLUMNS (
'Table #1' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
),
SUMMARIZECOLUMNS (
'Table #2' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
)
)
i was able to do this which worked for me
Combined Callers Summary =
UNION(
SUMMARIZECOLUMNS (
'Table #1' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
),
SUMMARIZECOLUMNS (
'Table #2' [Caller_Name],
"Caller Counts", [CALLER_COUNT]
)
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |