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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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'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