Total sum last year regardles of filters on page

[BobKoenen]

Hi all,

I have a report page with a Matrix table and a Month slicer. 

Customer	Sales this year	Sales previous year	Total sales previous year
A	100	120	700
B	40	50	500
C	90	120	1000

The measures [sales this year] and [Sales previous year] are dependent on the month slicer but I want the [Total Sales Previous year] measure to always show the cumulative sales of the entire previous year. 

Can you help me to get the formula for [Total Sales Previous Year]

[SanketBhagwat · Accepted solution]

Hi @BobKoenen .

You can use;

 [Total Sales Previous Year]=CALCULATE(SUM(table[column]),SAMPLEPERIODLASTYEAR(table[date])).

Regards,

Sanket Bhagwat.

If this post helps,then please mark it as 'Accept as Solution' so that other members could find it quickly.

[Tanushree_Kapse]

Hi @BobKoenen ,

Try using this measure:
Total Sales= CALCULATE(CALCULATE(SUM(Sales),ALL(Dates)),Previousyear(Dates))

Please give a thumbs up and mark it as a solution, if it answers your issue.

Thanks.