Populate a column using visual calculations and a lookup

Troekoe 
Hi, 1st use this
Forecast_Value =
VAR SelectedValue = SELECTEDVALUE('Table'[selectedvalue_tekst])
RETURN
IF(ISBLANK(SelectedValue), BLANK(),
DIVIDE(MAX('Table'[Forecast]), 12)
)

and then

Forecast_month =
VAR ForecastValue = [Forecast_Value]
RETURN
IF(ISBLANK('Table'[Forecast]), ForecastValue, ForecastValue)


Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Hi,

Thanks for the solution johnbasha33  provided, and i want to offer some more information for user to refer to.

hello Troekoe , based on your descrition, you can refer to the following solution.

Sample data is the same as you provided.

1.Create a calculated column in table.

Month_num = MONTH(CONVERT([Month]&" "&1,DATETIME))

2.Create a paramater table

3.Create the following measures

Forecast = MAXX(FILTER(ALLSELECTED('Table'),[Month_num]=[Parameter Value]),[SUMCUM])

Display_for = IF(SUM('Table'[SUMCUM])=[Forecast],[Forecast]) 

For_Month = DIVIDE([Forecast],12)

Output

The measure changes dynamically.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.