Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

CALCULATE(COUNTROWS(),(FILTER) function

Hello,    If I use the =CALCULATE(COUNTROWS(),(FILTER) function is there a way to show that if a row is blank, show 0?     
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    I think

    CALCULATE(COUNTROWS((FILTER ()) +0 , should work

     

amitchandak's avatar
amitchandak
Super User
6 years ago

I think

CALCULATE(COUNTROWS((FILTER ()) +0 , should work

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Amit 

     

    I tried the below and it doesn't work?