Sum of 4 table Visuals total In a card

[Karteek5371]

Hi Team
Need Urgent help on this scenario.

I have 4 table visuals in one page with the same columns but each table is filtered(Visual level Filters) with few months.

For Instance, 1st table is filtered with "feb 2022" and one"CompanyName(X CompanyColumn)"& 2nd table is with 'Jan&Feb' Month name and another "CompanyName(Y CompanyColumn)"

like this Follows the other 2 tables. I want another visual in a card visual & sum of total transaction amount of 4 table visual in the card.

Please let us know if any one worked on this scenario.
Thanks in advance

[v-chenwuz-msft · Accepted solution]

Hi @Karteek5371 ,

Unfortunately, there is no way for this to happen. Unless you fix the filtering of the four tables and then calculate the sum of each of the four tables by writing a measure. But when you make changes to the filtering of any of the tables, it does not change the card.

Measure =

var _table1 = calculate(sum('table'[account]),'table'[month]="feb 2022",'table'[CompanyName]="X")

var _table2 = calculate(sum('table'[account]),'table'[month]="Jan&Feb 2022",'table'[CompanyName]="Y")

var _table3 = ...

var _table4 = ...

return

_table1 + _table2 + _table3 +_table4

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523