Forum Discussion
Calculate() + Filter() not working as expected
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()
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 !!