Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
77 | |
68 | |
61 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |