DAX formulas working, but wont give correct result when slicer changes made.

[countryfan_nt]

Hello friends, hope all is well! please help.

The following DAX formulas works fine, and displays the average, max and min of values of all branches.
= CALCULATE(average(DB[LTM]), FILTER( DB, DB[Year]=earlier(DB[Year])&&DB[Month]=earlier(DB[Month])&&DB[Item]=earlier(DB[Item])) )
= CALCULATE(MAX(DB[LTM]), FILTER( DB, DB[Year]=earlier(DB[Year])&&DB[Month]=earlier(DB[Month])&&DB[Item]=earlier(DB[Item])) )
= CALCULATE(MIN(DB[LTM]), FILTER( DB, DB[Year]=earlier(DB[Year])&&DB[Month]=earlier(DB[Month])&&DB[Item]=earlier(DB[Item])) )

problem is I don't get the correct average, min, or max if I choose less branches through the slicers. (i.e. all branches have to be selected).

I wish for the formula to adjust based on the slicer selections. can that be done?

thank you so much in advance!

 

[Legacy 456129]

Possibly your slicer is looking at old cached data. In all my powerqueries and powerpivot sheets I got a macro to 'refresh' the caches linked to a buttonshape with the respective macro assigned. It's with complex setups rather slow hence why MS is likely to have chosen to go the cache route. A Snip from my code

140             With pt.PivotCache '26.05.2019 with merges
150                 .MissingItemsLimit = xlMissingItemsNone: .MissingItemsLimit = xlMissingItemsDefault: .Refresh
190             End With 'pt.