Error on total column

[wemersontm]

Hi Everyone...

I used a conditional measurement for my matrix. 

 SWITCH(TRUE(),

        SELECTEDVALUE(SELECTEDVALUE('Calendar'[month]) >= actual_Month, forecast_Value, actual_Value)
)

My intention is to show the actual value for months before the actual month and the forecast values for the upcoming months. The problem is on total, because the total column brings only the sum of the actual_Value instead of bringing the total sum of all twelve columns.

 Note: if you sum the 4 initial months, won't match the total on Total column because there is actual value in May as well, though it won't show the May actual value, the total amount is considering it on the total column

[Anonymous]

Hi @wemersontm ,

Please provide sample data in a usable form, as well as your expected results.

Best regards,
Community Support Team_ Scott Chang

[wemersontm]

Hi @Anonymous 
see the file on link below:

DRE_CANAL(Online) - Copia.pbix