How to ignore slicer in measure returning value for specific date

[Victoria_Bouts]

Hi all,

I'm working on Monthly closing of accounts model. Thanks to all of you  I proceed well in it.  All parts of model  are based on the same Sync slicer with selected Month and Year and linked to Calendar[Date]. But now I have a problem with devaluation of stock as it doesn't show in March 2022 amount of "start" devaluation from December 2021, if I chose December 2021 it shows wel (see pictures). So I just can't understand how to eliminate influence of slicer filter in measure. The idea at the end  to have delta between "closing date" and "start" devaluation.

I was searching a lot here for answer and trying to implicate different formulas (with var and return, removeallfilters, etc) but still didn't achieve my goal. That's why I decided to ask you.

Current measure is Deval adj Start = CALCULATE(SUM(Stock[Deval adj]), ALL(Stock[Month]),Stock[MonthYear]="December2021")

Any help would be highly appreciated

Thanks a lot in advance!

Victoria

[Victoria_Bouts · Accepted solution]

Hi all,

Found solution, it was simple actually, just Filter ALL of Calendar.Date

[tamerj1]

Hi @Victoria_Bouts 

closing Month slicer is from which table?

[Victoria_Bouts]

Hi,

Thanks for your interest to my problem!

The basic formula for all data is presenting data in YTD or Month view (see formula as example on revenues data)

For stock i switched off sync slicer as it shows the data at the last day of month, formula for stock is just SUM.

But still, as Stock is connected to Calendar date, it shows 2022 and 2021 separately

Best regards,

Victoria