Forum Discussion
Funcion Counta
Hola comunidad
Tengo la siguiente tabla en excel y cargada en power bi, ver imagen.
Estoy usando la función count para CONTAR las filas de la columna cantidad, pero no entiendo que algo o algo salga mal ya que debería contar 6 filas y solo cuenta 5.
Entiendo que la función count cuenta las filas incluyendo los valores que no están en blanco, pero no lo está haciendo
por favor ayuda, gracias
Thanks for the quick answer, but, it's not what I need to know, I could also use count and count the rows of the price column, I would get the same result. What I really want to know is why counta is not counting null values.
3 Replies
place COUNT write next measure
measure = DISTINCTCOUNT('Table'[Producto])Thanks for the quick answer, but, it's not what I need to know, I could also use count and count the rows of the price column, I would get the same result. What I really want to know is why counta is not counting null values.
where are null? it is empty and therefore does not count it.
in model null will be empty,
if you need to count rows, then you need to use COUNTROWS()
