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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.