Ignore the connected Date Slicer

[DJKarma]

I have two tables, One is the inventory and other is Date table, both are connected via date column.

I want to count no. of Inventory units from Inventory table with a filter on other colum in the inventory table Status.

This is my measure

Inventory Units =

CALCULATE(COUNTA('inventory_master (6)'[Unit]),'inventory_master (6)'[Status]

        IN { "R" ,"I","CB" }, REMOVEFILTERS (DateDimension[Date].[Year])

)

DateDimension is the Date table connected to Reg.Date column in my Inventory Table.

I want it to have all this status filter but ignore the Date Slicer which I have put on Report ( which is DateDimension)
As you can see i have used REMOVEFILTERS but it does not work.
I tried various methods in community but are not working.

Any help?

[amitchandak]

@DJKarma , Mark DateDimension as date table and have year column

Inventory Units =
CALCULATE(COUNTA('inventory_master (6)'[Unit]),filter('inventory_master (6)', 'inventory_master (6)'[Status]
IN { "R" ,"I","CB" }) , REMOVEFILTERS (DateDimension[Year])
)

[DJKarma]

Nope, Its not working, IF i edit the interaction and switch it off on the table where I am using the measure , it works (which was working previously as well), but I want that measure for further calculations where i cant switch off interaction. I want this Measure to be static regardless of any slicer with mentioned filters that is Status

[v-easonf-msft · Accepted solution]

Hi， @DJKarma 

Have you tried using REMOVEFILTERS (DateDimension[Date]) to replace REMOVEFILTERS (DateDimension[Date].[Year]) ?

Best Regards,
Community Support Team _ Eason