Calculating the average of a calculated measure

[bebeto]

Hi,

I have a bar chart which visualizes a calculation measure based on the months of the actual year, it shows:

The masure showed in the chart is calculated as:

EmpleadosActivosAnyoActual =
IF
(
MIN (DimFecha[Date]) <= TODAY ();
CALCULATE
(
[Personal naranja en plantilla];
FILTER(Empleados;Empleados[Fecha_incorporacion] <= MIN(DimFecha[Date]) && Empleados[date_to] >= MAX(DimFecha[Date]))
);
BLANK()
)

Where "Personal narnaja en plantilla" is:

Personal naranja en plantilla = CALCULATE(SUM(Empleados[EsNaranja]))

Now, I want to add a line showing the average of employees in the same chart (the average from January to July), but I don´t know how to do... Any suggestions?

Thanks!

[Anonymous]

@bebeto

You have to create a measure that calculates the average for the entire table.

This is done as

AveragefortheTable = Calculate(Average(TableName[ColumnName]), All(TableName))

This would generate the average for the entire table.

Use this to plot as a line in a combo chart.

Try it out.

If it works please accept this as a solution and also give Kudos. If it does not let me know what went wrong.

Cheers

CheenuSing

[bebeto]

I hace tried it and it doesn't work.

I want to get the average of employees actives from january to july of the current year (dynamycally). The data which I am showing is a calculated measure which shows the employees actives in each month of the current year.

I have:

So, the average should be:

(246 + 248 + 255 + 258 + 252 + 250 + 257) / 7 = 252.28

How can I get that?

[Vvelarde · Accepted solution]

hi @bebeto

The dax has to follow this syntax:

AverageTotal=AverageX(Summarize('Table';GroupColumn;"AveragePart";Formula);[AveragePart])