Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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()
place COUNT write next measure
measure = DISTINCTCOUNT('Table'[Producto])
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |