Promedio de un recuento

[GalanteJM]

Hola tengo una tabla CONSUMO de la cual quiero saber cuantos Registros promedios entre fechas cargo cada Usuario.

Tengo un campo Usuario, F_REGISTRO.

F_registro esta como segmentador de datos del informe.

Esto es o que quiero que se muestre:

Por favor si me pueden ayudar.

Si necesitan algun otro dato me avisan

[v-cgao-msft]

Hi @GalanteJM ,

Please try these measures:

Measure 1 = AVERAGEX(SUMMARIZE('CONSUMO','CONSUMO'[F_REGISTRO],'CONSUMO'[Etiquetas de fila],"@MLCAMISA",[MLCAMISA]),[@MLCAMISA])

Measure 2 = AVERAGEX(SUMMARIZE('CONSUMO','CONSUMO'[F_REGISTRO],'CONSUMO'[Etiquetas de fila],"@nbanchero",[nbanchero]),[@nbanchero])

Total general = [Measure 1] + [Measure 2]

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[GalanteJM]

Las columnas MCAMISA y nbanchero es un campo en una tabla combinada que se llama:

Nombre del campo: "USUARIOS", 

Se podra reformalar?

[v-cgao-msft · Accepted solution]

Hi @GalanteJM 

Please try create these measures:

Avg = CALCULATE(AVERAGE('Table'[Value]),ALLEXCEPT('Table','Table'[USUARIOS]))

Total = SUMX(ALLSELECTED('Table'[USUARIOS]),[Avg])

Measure = IF(ISINSCOPE('Table'[USUARIOS]),[Avg],[Total])

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[GalanteJM]

Muchas gracias