Show correct total amount

[feralvarez994]

Hi everyone! 

I have 2 issues with my table:

First one - I need to have the totals of VAR SALDO CC but i cannot make it visible, i dont know why. I am sure theres something wrong with my SUMX and SUMMARIZE used in the VAR SALDO CC measure

Second one - I would like to make subtotals of the positive VAR SALDO CC and negative VAR SALDO CC, adding each one and showing the positive and negative subtotal, can that be possible?

Both issues need to be shown in the table that is in the bottom part from the second page.

I am attaching the link with the PBI FILE im working, hope someone can give a hand!

PBI FILE

[tamerj1]

Hi @feralvarez994 
Please check if this is correct https://www.dropbox.com/t/sDfAGjv2UAnm8jvm

Also please clarify the 2nd part of your question.

[feralvarez994]

@tamerj1 Hi again! Thanks a lot for the quick answer. There's still something wrong with the totals. The total amount of VAR SALDO CC has to be the SALDO CC from the upper table. I dont know if i have done something wrong calculating the VAR SALDO CC. Also when i dont press any filter, the total amount is too big, i think because it calculates over all the rows in CTACTE, i only need to take in consideration the clients that are in SJ TRANSF table

About the second questions, i was trying to do something like this (if possible, if not theres no problem at all) just to make it clearer

Thanks again for everything that you do, and sorry if i cant explain myself as good as i want, english is not my main language haha

[tamerj1]

Hi @feralvarez994 
It is my mistake actually I did not read carefully. Please refer to the updated file https://www.dropbox.com/t/Wl4voLRK9swetyhv