Can you take the sum of two totals onto a separate visual?

[JamesTaylor92]

Hi all,

I am relatively new to Power Bi, and I am having a bit of difficulty with something that I was hoping to pick your brains on. I was wondering if it was possible in Power Bi to take the 'Totals' of two seperate visuals (as you can see below) and have a summary of them in another visual like a keycard maybe? So in theory the 2.00 you can see in the image should say 3.00. I have tried a number of ways to do this but manually but I was wondering if there was a specific string of code that could help achieve this?

Thanks,

James

[JamesTaylor92]

Thank you for your solution Pete, it was very helpful 🙂

James

[Anonymous]

Hi @JamesTaylor92 ,

Could you tell me if your problem has been solved by @BA_Pete 's suggestion? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin

[BA_Pete · Accepted solution]

Hi @JamesTaylor92 ,

You would do this with measures.

Your measures might look something like this:

_shift = SUM(yourTable[hoursWorked])

_shift2nd = SUM(yourTable[hoursWorked2nd])

_shiftPlusShift2nd = [_shift] + [_shift2nd]

You would use [_shift] and [_shift2nd] in your tables, and [_shiftPlusShift2nd] in your card.

Pete