Slicer is not working properly

[Anonymous]

I am a member of the community.

I have a measure that calculates the exponential increase in amount when the present value is increased by 5% in the future. It works okay when I visualise it using a line chart, but it fails when I slice the data using a date, giving me blank value. 

The file attached is a sample from @amitchandak. 

Future Value.pbix

Could someone please assist me with this? Any help would be greatly appreciated.

[Anonymous]

Thank you so much @amitchandak. I didnt notice that, I am still learning DAX.

[amitchandak · Accepted solution]

@Anonymous , Change allselected to all to go beyond the selected time to get values

measure = 
var _max = maxx(all(Data), Data[Date]) 
var _amt = calculate(lastnonblankvalue('Date'[Date], sum(Data[Amount])), ALL())
return if(Max('Date'[Date]) <=_max, sum(Data[Amount]), _amt* power(1.05, datediff(_max, Max('Date'[Date]), Day)+1) )