calculate sum of total from two different matrix visual with different filter

[failson]

hi all, currently I have two different matrix visual with different slicers filter. 

I want to calculate the sum of the total of these 2 matrix.

For example, the total expense of first matrix based on option A,B,C are 1,2,3 respectively; that of second matrix based on option D,E,F are 4,5,6 respectively

then when I choose A&D, it can return total 1+4=5, if I choose C&F, can return 3+6=9

I dont know whether power bi can do above, so  please help, thanks🙏

[Anonymous]

Hi @failson ,

If your data is just like this:

Then you can easily achieve your expected results through this DAX:

Sum of 2 matrixs = SUM(Table1[Value]) + SUM(Table2[Value])

But if your data is not like this, please provide your sample data so that we can better find a solution for you. Thank you!

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

[danextian]

Hi @failson 

Are the two matrices' data coming from the same or different tables?

Can you please provide a workable sample data (not an image) and your expected result from that? You may post a link to an Excel or pbix file in the cloud.

[rohit1991]

Hi Failson,

Yes, you can achieve this in Power BI using measures. Here's how:

1. Create measures for totals in each matrix: TotalMatrix1 = SUM(Table1[Expense])
   TotalMatrix2 = SUM(Table2[Expense])
   
   
2. Create a combined measure: CombinedTotal = [TotalMatrix1] + [TotalMatrix2]
   
   
3. Use the CombinedTotal in a card or visual to display the sum based on slicer selections.
   
   

4. Ensure slicer interactions are set correctly via Edit Interactions. This will update dynamically based on your filters.