add values ​​and ignore filters in the dimension

[guiibarbosaa92]

I have a dimension calendar with the following information:

using dax, how would you add the values ​​of hours in this dimension per month?

same as the example below:

[az38 · Accepted solution]

Hi @guiibarbosaa92 

try a measure

Horas Mes = 
CALCULATE(SUM([Horas]), ALLEXCEPT('Table', 'Table'[Mes]))

do not hesitate to give a kudo to useful posts and mark solutions as solution