Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @kattlees
You could try this
AR Balance =
VAR Bal = [Total Charges]+[Total Payments]
RETURN if(Bal=0,BLANK(),BAL)
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?
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
112 | |
97 | |
95 | |
64 | |
58 |