Summing values across rowns

[marciomendonca]

Good morning, community. I'm having this issue:

I have this table that contains productivity goals and I want to be able to sum these goals over the months, kinda like grouping (m1 = 1, m10 = 10, and so on...). But I also want this measure to be fully dynamic, so when one or more months is filtered, the correct goal value is shown.

Thank you!

Pessoal, bom dia. Possuo esta tabela que contém metas de produtividade de acordo com o respectivo mês e eu quero poder somar essas metas levando em consideração o mês, tipo um agrupamento (somar todos os valores do mês 1, com os valores do mês 2 e assim vai). Mas preciso que essa medida seja completamente dinâmica, dependendo dos meses selecionados, os corretos valores sejam mostrados.

Desde já, muito obrigado!

[tamerj1]

Hi @marciomendonca 

please try

Total Mes =
VAR TotalMes =
    SUMX (
        VALUES ( TableName[Mes] ),
        VALUE ( SUBSTITUTE ( TableName[Mes], "M", "" ) )
    )
RETURN
    M & TotalMes

[marciomendonca]

Unfortunately, it didn't do the trick. But I guess it was my own fault, let me try to explain once again:

I have this table and my plan is to have a slicer going from day 01/01 (january 1st) to 31/08 (august 31th), and also buttons to enable the person to select one or more months.

Depending on which month the person select I want to display to exactly productivity goal for the selected months. So, let's assume the month January, February and March were selected, I want it to show the corresponding productivity goal value for these 3 months. 

I kinda figured it out, but the math isn't right. For some specific months, the values didn't match at all and I simply can't discover why.

[tamerj1 · Accepted solution]

@marciomendonca 

From your description I can understand that you want to create a measure but from the screenshot I can see a calculated column! Please clarify. Also please share a screenshot of your visual for better understanding.