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...
v-janeyg-msft
Community Support
Community SupportHi, Anonymous
According to your needs, in theory, you only need to make your measure on 'values' not display 0 but display blank(), then empty rows should not be displayed automatically.
We don't know your data, and it is difficult to understand your situation based on the measures you provide.
If you can share some insensitive data and expected output to help us clarify your scenario, you can help you soon.
Best Regards,
Community Support Team _ Janey
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