Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |