Dynamic Table based on selected value

[Anonymous]

Hi everyone, 

I would like to create a table based, such as: 

MonthTable =

ADDCOLUMNS(

GENERATESERIES(1, 12, 1), 

"ValueInPesos",

VAR SelectedYear = SELECTEDVALUE(Calendar[Year]),

RETURN

CALCULATE(

[ValueInPesos],

FILTER(

'EXP (Summary)',

'EXP (Summary)'[Año] = SelectedYear 

)

) / 12

)

My goal is to divide a budget for a specific year by 12 in order to equal repartition over the months. My problem is that when I select a specific year from my calendar ('EXP (Summary)'[Año] is linked to my Calendar[Year]), I got blank values and so no values. If I change SelectedYear by a constant value (like 2024), it works. In my opinion, it is simply that my table doesn't get access to the selected value. 

Does anyone know how to solve this issue?

[lbendlin · Accepted solution]

You cannot create calulated columns or calculated tables from measures or filters.  Only the other way round.