Return value for a specific year and not sum of all years

[sgupta22]

I am using the following code to return the value for the first year of the slicer.  However, the value returns as the sum of all years. What am I doing wrong? Any help is appreciated! 

BeginningValue =
     VAR BeginningDate = CALCULATE(MIN('Calendar'[Year]), ALLSELECTED('Calendar'[Year]))
RETURN
     CALCULATE(SUM(Data1[Total Revenue]), FILTER('Calendar', 'Calendar'[Date] = BeginningDate))

Cheers

Shashank

[v-zhangti · Accepted solution]

Hi, @sgupta22 

You can try the following methods.
Sample data:

BeginningValue = 
     VAR BeginningDate = CALCULATE(MIN('Calendar'[Year]), ALLSELECTED('Calendar'[Year]))
RETURN
     CALCULATE(SUM(Data1[Total Revenue]), FILTER('Data1', YEAR([Date]) = BeginningDate))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[mangaus1111]

Hi @sgupta22 ,

try to substitute 

 'Calendar'[Date] = BeginningDate)  with

'Calendar'[Year] = BeginningDate) 

[sgupta22]

Thanks for your reply Mangaus.  Still doesn't work unfortunately.