Forum Discussion

Santy241's avatar
Santy241
Frequent Visitor
1 year ago
Solved

Average in Power Bi Matrix

Hi everyone! šŸ‘‹ Iā€™m new to Power BI and I need your help using matrix visuals

 

Iā€™m trying to recreate the structure of the following Excel summary in Power BI, using a matrix visual. The actual values are not the problem ā€” what I need is to replicate this structure, including hierarchical averages:

 

My setup in Power BI:

  • Data table: BaseHistorica_Pedidos

  • Measure: Productivity H = [Completed H] / DISTINCTCOUNT([Technician: Name])

  • Fields available:

    • Contratista (contract)

    • Tecnologia (technology)

    • Tipo Agenda (calendar: D or N)

    • Fecha Inicio Agendado (used as column header with Day hierarchy)

 

How can I reproduce this exact structure in a Power BI matrix?

 

Need Help
  • MFelix's avatar
    MFelix
    1 year ago

    Hi Santy241 ,

     

    Depending on how you have the tables setup I would create a measure with the following code:

    IF(ISINSCOPE(Table[Calendar], [Productivity H], AVERAGEX(VALUES(Table[Technology]), [Productivity H])

     

    Be aware that without any data is difficult to give you a better formula.

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    1 year ago

    Hi Santy241 ,

     

    Depending on how you have the tables setup I would create a measure with the following code:

    IF(ISINSCOPE(Table[Calendar], [Productivity H], AVERAGEX(VALUES(Table[Technology]), [Productivity H])

     

    Be aware that without any data is difficult to give you a better formula.