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

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous you can do something like this

     

    your measure = caclulate(countrows(), filter()) + 0

    Would appreciate Kudos 🙂 if my solution helped. 

     

  • 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?