Measure sums for categories but not for total

[RTERCERO]

Hello,

I have a measure that present calculations properly when in separate visuals but when in the same one does not sum properly:

The calculations to match in separate graphs, (see red rectangle), and when I place then in the same table individual values add perfectly but totals just in  "Horas Jornada" which is man hours per shift do not (see yellow rectangle should be "129,720"):

This is the formula I use for "Horas Jornada" (man hours per shift) :

Horas de Jornada = 
    COUNTROWS('Calendario de Grupos')*
    CALCULATE([Activos X Fecha],FIRSTNONBLANK('Calendario de Grupos'[Grupo],'Calendario de Grupos'[Grupo]))
    *12

Second Isue is when I try to filter by Business unit Absent hours disappear (red rectangles):

These are the relations:

Tables explanation:

"Masestro_empleados" is the list of all employees active and inactive with the date of hiring and retired date, I use this to calculate how many active we have each day, the formulas is Active per date:

Activos X Fecha = 

      CALCULATE(COUNTROWS(
    CALCULATETABLE('maestro_empleados (Ausentismo)',
    FILTER('maestro_empleados (Ausentismo)',
    'maestro_empleados (Ausentismo)'[FECHA INGRESO]<=MAX('Calendario de Grupos'[Fecha])
    && 'maestro_empleados (Ausentismo)'[ESTADO]="A"))))
+
    CALCULATE(COUNTROWS(
    CALCULATETABLE('maestro_empleados (Ausentismo)',
    FILTER('maestro_empleados (Ausentismo)',
    'maestro_empleados (Ausentismo)'[FECHA INGRESO]<=MAX('Calendario de Grupos'[Fecha])
    &&'maestro_empleados (Ausentismo)'[FECHA RETIRO]<>BLANK()
    &&'maestro_empleados (Ausentismo)'[FECHA RETIRO]>=MIN('Calendario de Grupos'[Fecha])
    && 'maestro_empleados (Ausentismo)'[ESTADO]="R"))))

"Calendario Grupos" its the team and shift information for each date, This is not my main calendar, there are other tables in the complete model that have a relation to the actual man calendar which is: "Calendario"

"Ausentismo Manual" is the absenteeism registry, who was absent how many hours and when

"UNIDADES" is a table to group business units according to leader

"Grupo Texto" is a table with the team names that i used to remove the many to many relationship Between "Calendario" and "Maestro_empleados"

I'm attaching the model : 
https://we.tl/t-jcK1Uv490D

RT

[Anonymous · Accepted solution]

Hi @RTERCERO,

I think these should relate to the nested basic measure. AFAIK, the measure formula is calculated on row content and you can use one function to extract the current row contents. These functions' results will be changed when you use them on different row content levels.

For this scenario, you can try to write a variable with summarize function to manually keeping raw content contents aggeration. Then you can use iterator functions on them to summary these results.

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng