Forum Discussion

magtuto's avatar
magtuto
Helper I
9 years ago
Solved

Count All Rows No Blank

Hello All,

 

I thought this would be simple to do.  Im just finding it difficult to create a measure that counts the number of rows, ignoring all blank rows.  I thought that the 'ALLBLANKROW' function would be ideal.  Its not nworking for me.

 

Basically, I have the following column in the table that I want to count and it cointained one blank.  I dont want to count this blank so when I do a count I want 3.  Whats is the best way to to this?

 

Last Login |

23/09/16   |

22/09/16   |

                 |

21/09/16   |

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    magtuto Have you tried =COUNTA('table'[column])? Counts the values, not blank in my quick test.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    magtuto Have you tried =COUNTA('table'[column])? Counts the values, not blank in my quick test.

    • magtuto's avatar
      magtuto
      Helper I
      9 years ago

      Eno1978

       

      Actually I did end up just creating a measure basically that performed COUNTA - COUNTBLANK calculations.

       

      Works!

    • magtuto's avatar
      magtuto
      Helper I
      9 years ago

      Eno Apologies.

       

      The COUNTA measure does eliminate blanks.