cancel
Showing results for
Did you mean:
Helper IV

## Total sum last year regardles of filters on page

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]

1 ACCEPTED SOLUTION
Responsive Resident

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.

2 REPLIES 2
Responsive Resident

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.

Continued Contributor

Hi @BobKoenen ,

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

Thanks.

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.