Forum Discussion

Mahar92's avatar
Mahar92
Frequent Visitor
5 years ago
Solved

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)....
  • VahidDM's avatar
    VahidDM
    5 years ago

    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  !!

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
5 years ago

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  !!