Forum Discussion
Summing values across rowns
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.
please try
Total Mes =
VAR TotalMes =
SUMX (
VALUES ( TableName[Mes] ),
VALUE ( SUBSTITUTE ( TableName[Mes], "M", "" ) )
)
RETURN
M & TotalMes
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.
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.