Forum Discussion
Filter Matrix table to exclude zero balances
Hey Guys I created this Matrix table that shows outstanding debtor balances as an aged analysis. I don't want to show debtors with a zero balance. Been struggling to get it right in DAX...
Thank you so much for your reply Janey
I will get some data together & upload just so we can get to the bottom of all of this
Thnaks again
Deon
BTW - I totally hashed the measure that I provided, so no doubt you would have been confused 🙂
Apologies for that
- v-janeyg-msft
Community Support
Anonymous
Because your formula involves different tables and is used in a matrix (complex context) visual, so just sharing measure is not enough to modify, we need data to analyze. Of course, it would be great if you could follow my advice and modify it yourself.
Best Regards,
Community Support Team _ Janey
