Matrix Total is Not Correct - Specific Date

[jnguyen21]

I'm putting together data that shows actuals up to a given month, and the rest of the year budget. The issue I am having is the total is not adding up correctly for the Budget ROY Column. The logic is if a specific month is selected, that month and the remainder of the year will populate budget. The beginning of the year will be zero. While the grid rows are correct, the total row is not. It is showing the same total for both the Budget and Budget ROY column

Can you let me know what my issue is?

Budget ROY =

var first_day = min('Calendar'[FirstDayofYear])   

var last_day = max('Calendar'[LastDayOfPeriod])  

return  

IF(SELECTEDVALUE('Calendar'[LastDayOfPeriod])  )>= first_day && SELECTEDVALUE('Calendar'[LastDayOfPeriod])  <=last_day,[Budget],0)

[jnguyen21 · Accepted solution]

I was able to find my issue by referencing the below video

https://www.youtube.com/watch?v=Rii_6qkLNh8

[jnguyen21]

Thank you for responding, but that doesn't look like that worked either. It is doing the same thing as totaling up the budget column. It looks like the zero that's being put in does not remove the volume from the measure, just hides it. 

[amitchandak]

@jnguyen21 , Based on the row/group by of you visual, change like

Budget ROY =
var first_day = min('Calendar'[FirstDayofYear])
var last_day = max('Calendar'[LastDayOfPeriod])
return
Sumx(values('Calendar'[Fiscal Period]) , IF(SELECTEDVALUE('Calendar'[LastDayOfPeriod]) )>= first_day && SELECTEDVALUE('Calendar'[LastDayOfPeriod]) <=last_day,[Budget],0) )