Hide Zero Values in Matrix

[rbalza]

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.

[amitchandak]

@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.