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).

 

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

2 Replies

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