Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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 !!
That did the trick. Thank you!
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 !!