Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Average calculation grouped by project

Hello, I have a problem to perform a calculation in PowerBi, at the moment I had to do it manually in Excel and I need it to be done in a dynamic way. The problem is the following tengun a base wit...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

You can solve this in Power BI by creating a measure that first adds up the hours by Task and Project and then averages over those totals. For example:

PromedioPorTask =
AVERAGEX(
    SUMMARIZE(
        Tabla,
        Tabla[Cod Proyecto],
        Tabla[Task],
        "HorasProyecto", SUM(Tabla[Horas])
    ),
    [HorasProyecto]
)

This measure will ensure that it is first grouped by project and task, add up the hours, and then take the average, also allowing you to apply dynamic filters according to client, type or any other field.