Filter out unnecessary slicer items

[dhannaa]

Hi all, 

My report is calculating stock values for any selected date, like this:

AccumulatedValue = 
CALCULATE (
    SUM ( Item Ledger Entry'[Quantity] );
    FILTER ( ALL ( 'Calendar' ); 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) )
)

I have a lot of slicers in my file and at the moment they are showing also items that doesn't give any results (locations and items that no longer exist and so on). Is there any way to remove such slicer items automatically? I don't want to filter them out manually as there is always possibility that some non-existing stock is used by mistake.

What would be the smartest move here? 

Jenny

[Greg_Deckler]

Filter out AccumulatedValue that are blank or 0?

[dhannaa]

@Greg_Deckler

Accumulated value that is 0.

For example - qty for stock that has been shut down is 0 even if there are positive and negative changes in the past - accumulated value is at this moment 0.

Empty table for filter with no stock at the moment

Closed location is not needed here. List gets already long with current locations themselves

 --

Edit:

Forgot to mention, that I am filtering my source data with a date slider

[dhannaa]

Any ideas on this 🙂 ?

[dhannaa]

I am still struggling with this as my slicers are showing a long list of closed warehouse locations. I don't find a solution to exclude them even though I am trying hard. 

Jenny