Particular column shouldn't be filtered by slicer

[fbron]

I have a dataset based on the following tables:

- Company

- Item

- Item Ledger Entry

- Sales Header + Sales Line

- (+add Measures)

Between the tables Ive made the following relationships:

Relationship between tables

Based on this dataset I'm trying to generate a table based on:  'Item'[search descrition]

All info in the table comes from either from the 'Item" table or 'Sales line' and is allowed to be filtered by the date slicer on top of the screen (based on 'SalesHeader'[orderdate]) 

Current situation: "stock" is influenced by date slicer

What I'm trying to do next is add a "stock" column/measure  based on the column 'item ledger entry'[remaining quantity]

As you can imagine, this column shouldnt be effected by the Date slicer while stock is just stock. 

Whats the best way to prevent this column from being effected by the dateslicer?

[v-shex-msft · Accepted solution]

HI @fbron,

Did you mean to ignore the specific filter effects between power bi tables? If that is the case, you can consider adding all functions to the Dax formula to prevent particular field filter effects. 

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI

Regards,

Xiaoxin Sheng

[amitchandak]

@fbron , Try a measure like

new stock = calculate([stock], all(Date))

or

new stock = calculate([stock], removefilters (Date))

[fbron]

Thanks for the quick response... 

Unfortunately your suggested solution(s) don't seem to work in my case. 

Seems like you refer to Date as a Table while the date slicer I'm using is based on the column [Order date] from the table 'Sales Header'. Does that mean that I have to work with a date table?