Calculate() + Filter() not working as expected

[Mahar92]

Hi,

in my Pivot table I want to display the sales for the first year (2014) irrespective of the current filter context (so even in the section for year 2015 I want to display the sales for 2014).

To achieve this, I would assume that I could use both of the following DAX measures:

=CALCULATE([Total Sales],qryCalendar[Year]=2014)

=CALCULATE([Total Sales],Filter(qryCalendar,qryCalendar[Year]=2014))

However, only the first of the two works as expected (first picture). The second one that uses Filter() only returns blank cells in all sections other than 2014

. 

Can anyone tell me why it is not working for me?

Calculate()Calculate() + Filter()

[Mahar92]

That did the trick. Thank you!

[VahidDM · Accepted solution]

Hi @Mahar92 

try this=
=CALCULATE([Total Sales],Filter(all(qryCalendar),qryCalendar[Year]=2014))

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos  !!