Forum Discussion
rbalza
Helper III
Helper IIIHide Zero Values in Matrix
Hi Everyone,
How to hide column with zero values? Seen couple of forums here and found nothing that works in my case. I even filter on page visual.
My measure on total is:
Totals = [Op Bal Interim Transactions] +
CALCULATE(
[Journal Lines Total] ,
FILTER(
ALLSELECTED( Dates),
Dates[Date] <= MAX( Dates[Date])
)
)
Appreciated your help on this.
2 Replies
- amitchandak
Super User
rbalza , Try like
Totals =
var _1 = [Op Bal Interim Transactions] +
CALCULATE(
[Journal Lines Total] ,
FILTER(
ALLSELECTED( Dates),
Dates[Date] <= MAX( Dates[Date])
)
)return if(_1= 0, blank(), _1)
- rbalza
not working 😞 Appreciate your help.
