get total value at the bottom after applying if condition to our column

[santossssshhh]

I am working on a trial balance report where i have values like opening debit and credit, periodic debit and credit and closing debit and credit. While calculatinng opening debit and credit, I use a condition - if(debit > credit, debit - credit,0) for debit column and 

if(credit > debit, credit - debit,0). It works well for the above rows, but I don't get total sum of these values at the bottom. I need the total values at the bottom. I've searched all over the internet but couldn't find it. 
Is there anyone to help me with this???

[parry2k]

@santossssshhh provide more details, how your data model looks like? What you are using on the rows. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[parry2k]

@santossssshhh change your measure to this:

SUMX ( VALUES ( YourTable[ColumnOnRow] ),
if(credit > debit, credit - debit,0)
)

[santossssshhh]

It doesn't work. Have a look on my table. It compares the first two columns and uses the formula for finding greater value and subtracting. I need the sum of all the rows compared.