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.
saludos.
Mi dura está en como usar el promedio de forma correcta.
El problema es que el promedio se calcula con base en los totales de cada columna:
el promedio de la columna "Promedio de SFV_Time elapsed__c FVJ es de 3.7, sin embargo el power bi se muestra 2.6, esto es porque está sacando el promedio de los totales, lo cual no es correcto para el fin que estoy buscando. pongo ejemplos en power bi y excel.
power bi hace bien la división en las filas individuales, pero al poner varias filas hace el promedio con los totales. ayuda porfavor
Solved! Go to Solution.
Hi @Anonymous
You can try something like the following measure:
FVJ =
VAR _1 =
AVERAGE( 'Table'[SFV_Time_elaspsed_c] )
/ AVERAGE( 'Table'[SFV_Time_elaspsed_c cuenta] )
VAR _2 =
ADDCOLUMNS(
ALL( 'Table' ),
"avg", DIVIDE( [SFV_Time_elaspsed_c], [SFV_Time_elaspsed_c cuenta] )
)
VAR _3 =
AVERAGEX( _2, [avg] )
RETURN
IF( HASONEVALUE( 'Table'[ID] ), _1, _3 )
Result:
I put the pbix in the attachment you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can try something like the following measure:
FVJ =
VAR _1 =
AVERAGE( 'Table'[SFV_Time_elaspsed_c] )
/ AVERAGE( 'Table'[SFV_Time_elaspsed_c cuenta] )
VAR _2 =
ADDCOLUMNS(
ALL( 'Table' ),
"avg", DIVIDE( [SFV_Time_elaspsed_c], [SFV_Time_elaspsed_c cuenta] )
)
VAR _3 =
AVERAGEX( _2, [avg] )
RETURN
IF( HASONEVALUE( 'Table'[ID] ), _1, _3 )
Result:
I put the pbix in the attachment you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |