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 ...
amitchandak
Super User
Super Userrbalza , 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.
