Reply
Regular Visitor
Posts: 18
Registered: ‎08-01-2017

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

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.

 

 

 

 

Highlighted
Regular Visitor
Posts: 38
Registered: ‎09-20-2017

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

Try this measure:

 

actualCount = COUNTA(dOA[Category])+0

Regards!

Regular Visitor
Posts: 18
Registered: ‎08-01-2017

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

[ Edited ]

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

 

counts.PNG

Established Member
Posts: 227
Registered: ‎07-13-2018

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

try count > 0 in a measure?

 

Regular Visitor
Posts: 18
Registered: ‎08-01-2017

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

wat?

Frequent Visitor
Posts: 19
Registered: ‎10-31-2017

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

[ Edited ]

I think he meant something like this:

Var _count = counta(dOA[Category])
Return IF( _count > 0, _count, 0)
Established Member
Posts: 227
Registered: ‎07-13-2018

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

@justinh thanks or the clarification