Forum Discussion

DJKarma's avatar
DJKarma
Frequent Visitor
4 years ago
Solved

Ignore the connected Date Slicer

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...
Need Help
Show and Tell
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi， DJKarma 

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

     

    Best Regards,
    Community Support Team _ Eason

DJKarma's avatar
DJKarma
Frequent Visitor
4 years ago

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's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi， DJKarma 

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

 

Best Regards,
Community Support Team _ Eason