Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter axis but not data

I´m going to write an example of the question I´m trying to solve: A Transaction table records each time a Coca Cola is withdrawed from or added to a shelve. It is connected with a Date table. This...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi, 

     

    If you use ALL instead of ALLSELECTED: 

    Stock = 
CALCULATE(
	SUM(('Transactions'[Quantity]));
	FILTER(
		ALL(Calendar[Date]);
		ISONORAFTER(Calendar[Date]; MAX(Calendar[Date]); DESC)
	)
)

     is this what you want to achieve?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, 

 

If you use ALL instead of ALLSELECTED: 

Stock = 
CALCULATE(
	SUM(('Transactions'[Quantity]));
	FILTER(
		ALL(Calendar[Date]);
		ISONORAFTER(Calendar[Date]; MAX(Calendar[Date]); DESC)
	)
)

 is this what you want to achieve?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous Yes! I overlooked the 'ALL'. Thanks!