DAX help: Ignoring Date Slicer on Page and Using a Static Date in Calculation

[BlueRanger]

Hello,

I am running the following calculation to determine the total end employee count:

I need to modify this calculation to ignore the date slicer on my report page and instead filter on the date ending 1-24-22.

Any help would be appreciated!

Thank you

[BlueRanger · Accepted solution]

Thanks! I eneded up finding a solution to this problem by disconnecting my visual with this calculation from the slicer and then adding a filter to the visual with the desired date.

[ChiragGarg2512]

@BlueRanger , Use only the required date instead of the whole date column. This problem is pretty unclear as to where this date has to be placed. 

To put the date in the DAX use date(22, 24, 1) instead of writing date directly.

Thank you.