Matrix - put 0 value in empty cell. ISBLANK/Blank() fail on true part.

[bartus1]

I am displaying counts per category for people in matrix.  All works fine, but empty cells(columns) don't show up.

I've been trying to use IF/ISBLANK to remedy this but the empty=true never works.  All still displays fine for empty=false.

My statement:

actualCount = IF(ISBLANK(COUNTA(dOA[Category])), 0, counta(dOA[Category]))

or

actualCount = IF(ISBLANK(COUNTA(dOA[Category])), "zero", counta(dOA[Category]))

The conts display properly, but blanks never get replaced by 0/zero

Any ideas?  Thanks.

[Anonymous]

try count > 0 in a measure?

[bartus1]

wat?

[justinh]

I think he meant something like this:

Var _count = counta(dOA[Category])
Return IF( _count > 0, _count, 0)

[Anonymous]

@justinh thanks or the clarification

[CrisYan]

Try this measure:

actualCount = COUNTA(dOA[Category])+0

Regards!

[bartus1]

^Thanks.  It did not change anything.  Empty cells have nothing in them.