Year Total in Column for Each Year

[GilbertQ]

I am hoping that someone can help me with the DAX calculation.

What I want to do, is I want to get the total for each Year into a column, so that I can calculate the variance.

So as an example the total for Fiscal Year  2014-15 is 3,109,234 and I want to get the "Year Total Amount" as a DAX calculation. And I want it to dynamically change based on each Fiscal Year. Currently I have not found a DAX calculation in how to make it dymancially represent the total for each Fiscal Year.

I can only do it for ALL the dates. Any help or suggestions would be appreciated.

 Month 	 	Fiscal Year 	 Total Amount 	 Year Total Amount 
 July 	 	2014-15 	 222,240 	 3,109,234 
 August 	2014-15 	 502,727 	 3,109,234 
 September 	2014-15 	 196,123 	 3,109,234 
 October 	2014-15 	 246,279 	 3,109,234 
 November  	2014-15 	 216,672 	 3,109,234 
 December 	2014-15 	 336,935 	 3,109,234 
 January 	2014-15 	 264,282 	 3,109,234 
 February 	2014-15 	 232,351 	 3,109,234 
 March 	 	2014-15 	 216,005 	 3,109,234 
 April 	 	2014-15 	 210,155 	 3,109,234 
 May 	 	2014-15 	 216,637 	 3,109,234 
 June 	 	2014-15 	 248,827 	 3,109,234 
 July 	 	2015-16 	 241,957 	 3,020,604 
 August 	2015-16 	 323,376 	 3,020,604 
 September 	2015-16 	 245,660 	 3,020,604 
 October 	2015-16 	 307,581 	 3,020,604 
 November  	2015-16 	 261,458 	 3,020,604 
 December 	2015-16 	 290,593 	 3,020,604 
 January 	2015-16 	 184,431 	 3,020,604 
 February 	2015-16 	 196,787 	 3,020,604 
 March 	 	2015-16 	 226,399 	 3,020,604 
 April 	 	2015-16 	 187,208 	 3,020,604 
 May 	 	2015-16 	 216,522 	 3,020,604 
 June 	 	2015-16 	 338,632 	 3,020,604 

[GilbertQ · Accepted solution]

To any one looking for the solution I figured it out.

The following DAX Syntax works

Total Amount Per Year = CALCULATE([Total Amount],ALL('Date'),VALUES('Date'[Fiscal Year]))

[genre]

hi

this dax doesnt work for me. could u please help post the dax with real example that works for u ? thanks