Average in Power Bi Matrix

[Santy241]

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?

[MFelix · Accepted solution]

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.