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
Me vuelve loco porque intenté todo lo que sé para resolver este pequeño pero frustrante problema. Cuando marco una región en la sección de filtros PowerBi calcular el valor correctamente, pero... cuando elijo más de uno da un valor promedio incorrecto. ¿Alguna idea? Por favor, 🙂
Solved! Go to Solution.
Issue solved. For others looking for explanation: assumptions were wrong. PowerBi calculates values properly. The important thing to remember is that you do not take average value from partial averages to get information about global 😉 So simple but when there is so much work it is easy to forget about the simplest things 😉
Issue solved. For others looking for explanation: assumptions were wrong. PowerBi calculates values properly. The important thing to remember is that you do not take average value from partial averages to get information about global 😉 So simple but when there is so much work it is easy to forget about the simplest things 😉
@MagdalenaH, ¿cuál es su fórmula promedio
Eso podría estar dando Promedio ponderado. Puede probar como, Valores de la columna después de lo cual desea tomar simple Promedio
AverageX(Values(Table[Date]),[Fórmula promedio])
O
AverageX(Values(Table[Tags]),[Fórmula promedio])
@amitchandak Gracias por un consejo. El cálculo detrás de él es muy simple: DIVIDE([Completed],[Total],0)
Completado:
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 |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
1 | |
1 |