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...
amitchandak
Super User
Super UserAnonymous , Create a measure like this and use that in the visual level filter. Check <> 0
measure = calculate([meausre], filter(allseleceted(Table), Table[Brand] = max(Table[Brand]) && Table[Customer No] = max(Table[Customer No])))
Hey Amitchandak
Still a little lost with this one......
Below is a copy of my fields panel:
2 x tables, a measure and a column involved
The measure at the top (#Customer Balance) is the one that I am busy with but not quite there yet 😞