Show the accumulated balance with a filter

[kattlees]

I am trying to create a list of people who have an outstanding balance. 

I have these measures:

Total Charges = CALCULATE(sum('Guest Charges and Payments'[Amount]),'Guest Charges and Payments'[Type]="Charge")

Total Payments = CALCULATE(sum('Guest Charges and Payments'[Amount]),'Guest Charges and Payments'[Type]="Payment")

AR Balance = [Total Charges]+[Total Payments]

It is working great except I would only like to see those people with a BALANCE. so if they have a $0.00 balance, I would like them to not show up on my list.  Is there a way to do this?

I have tried setting a filter where AR Balance is not 0

[Phil_Seamark]

Hi @kattlees

You could try this

AR Balance = 
VAR Bal = [Total Charges]+[Total Payments]
RETURN if(Bal=0,BLANK(),BAL)

[kattlees]

That makes some of the zero balances blank, but still shows them. I don't want them on the report if there is a zero balance.

 See screenshot.  Also, any idea why some zero balances are showing negative and some not?

[Phil_Seamark]

Hi @kattlees

What is the difference between a zero balance and one that is a net zero balance?