Calculated Measure Not Changing with Filters/Slicers

[mstan]

Hi All,

I've created a calculated measure (below) to show the sum of the previous week's numbers.  Everything looks fine until I try to adjust any of the [several] slicers on the page- I expect that sum to adjust but the amount remains unchanged/unaffected. 

Any help would be greatly appreciated, I am stuck. 

Previous Week =

CALCULATE ( 

SUM ( disputes[amount] ) ,

FILTER ( 

    ALL ( 'disputes' ) ,

    disputes[Year] = SELECTEDVALUE ( disputes[Year] ) &&

    disputes[WeekNum] = SELECTEDVALUE ( disputes[WeekNum] )-1 ) )

[Clinical_Epi · Accepted solution]

Hi there, the addition of "ALL ( 'disputes' ) " in your measure is having the affect of keeping you from filtering. 

When adding a function to a measure normally you can see the specific intention in a pop - for "ALL" the pop up says 'Returns all the rows in a table, or all the values in a column, IGNORING ANY FILTERS that might have been applied)....

The last bit of that comment in the fucntion = "might" = is important, what they (microsoft) actually mean is it WILL ignore ALL filters.. wether or not they are applied... but to be sure check to see if there is one in the side "filter" bar. I assume you made this dashboard, but in case you didn't sometimes people filter things, then hide the side filter bar..

Just remove "ALL" and you'll be fine 

Kind regards

Clin EPI

[zachmas]

Hi sorry to interrupt, I am trying to measure sales previous weeks, and last 2 weeks, so on so forth. Removing the ALL in FILTER works with the current week DAX, however when it is applied to the last 2 weeks DAX, it shows blanks

This is the original DAX, when the ALL is removed then is returns blank. Any opinion on this?

[mstan]

After changing the data type in PowerQuery rather than in the data view, this worked. Thank you kindly!