Forum Discussion

wOOLRITCH's avatar
wOOLRITCH
Frequent Visitor
6 years ago
Solved

Summarize data from two columns in separate tables

Hey everyone! First, im an excel-guy who is new to PBI but am trying hard to learn as fast/much as possible. Im having trouble with understanding how i can summarize data from Column A in Table...
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You can solve this with a measure (and should).  Assuming you are using fields from the Date and Markets tables in your visuals for axes, legends, etc., you should be able to make a new measure like this:

     

    Total Interactions = [Number of incidents] + [Number of chats]

     

    Have you tried that already?

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

wOOLRITCH's avatar
wOOLRITCH
Frequent Visitor
6 years ago

Hey, Thanks alot for the support.

Yes, it works. But i had to put the measure for "total interactions" under the "incident table"...

And i guess i wanted it to be better structured (so totals are seperately and not placed under "incidents" in this case).

If you know how i could do that, please let me know 🙂

Isnt it possible to create a new table for just "totals" and place the measure there somehow?

THanks!

/W