cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MagdalenaH
New Member

Valor medio incorrecto al seleccionar etiquetas en filtros

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, 🙂Filters.png

1 ACCEPTED SOLUTION
MagdalenaH
New Member

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 😉

View solution in original post

3 REPLIES 3
MagdalenaH
New Member

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 😉

View solution in original post

amitchandak
Super User
Super User

@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])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

@amitchandak Gracias por un consejo. El cálculo detrás de él es muy simple: DIVIDE([Completed],[Total],0)

Completado:

Calcular
COUNTA('RawData'[Total]),
'RawData'[Estado]
EN "Completado", "Completado (Auto-Asserted)", "Desactivado"

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!