Duplicate values of last mounth in new column matrix

[marcosds]

Hi, what am I doing wrong?

I have the columns: every month, average, last month(november).

--I made a measure that fills every month (ok)

--Calculate the average (ok)

--But it doesn't fill in the "last month" column. Detail: returns values of november (tested alone), but does not fill the column 

Measure =

VAR AVARAGE_ROW = CALCULATE(AVERAGE(Table[Value]), ALLEXCEPT(Table, Table[Row]))
VAR SUM_ROW = CALCULATE(SUM(Table[Value]), FILTER(Table, Table[Mounth_Index] = 11))

VAR result =
IF(
SELECTEDVALUE(Table[Column])="AVARAGE", AVARAGE_ROW,

IF (
SELECTEDVALUE(Table[Column])="Last Mounth", SUM_ROW,
SUM(Table[Value])
)

)

RETURN result

##### results in matrix
November | AVARAGE | Last Mounth
1                |        2       |           
1                |        2       |           
1                |        2       |           
1                |        2       |           
1                |        2       |           

##### expected

November | AVARAGE | Last Mounth
1                |        2       |            1
1                |        2       |            1
1                |        2       |            1
1                |        2       |            1
1                |        2       |            1

[amitchandak · Accepted solution]

@marcosds , if Mounth_Index is filtered you need all

Try this change

VAR SUM_ROW = CALCULATE(SUM(Table[Value]), FILTER(all(Table), Table[Mounth_Index] = 11))