Forum Discussion

GalanteJM's avatar
GalanteJM
Regular Visitor
2 years ago
Solved

Promedio de un recuento

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 i...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
GalanteJM
Regular Visitor
2 years ago

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

Nombre del campo: "USUARIOS", 

 

Se podra reformalar?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    GalanteJM
    Regular Visitor
    2 years ago

    Muchas gracias