Count All Rows No Blank

[magtuto]

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   |

[kousar99]

@magtuto  Hi

could please tell how you created measure for the same

[Anonymous · Accepted solution]

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

[magtuto]

Eno Apologies.

The COUNTA measure does eliminate blanks.  

[magtuto]

Eno1978

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

Works!