Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
stribor45
Post Prodigy
Post Prodigy

Adjust my current DAX formula for the virtual table

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]
)
1 ACCEPTED SOLUTION
stribor45
Post Prodigy
Post Prodigy

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]
    )
)

View solution in original post

1 REPLY 1
stribor45
Post Prodigy
Post Prodigy

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]
    )
)

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.