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

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

Not applicable

6 years ago

Hi Anonymous

My approach would be to create a new column in the "Calendar" table to calculate the stock on the shelve at that moment. See dax for column below:

QtyOnShelf = CALCULATE(

SUM(Transactions[Quantity]) ,

FILTER(Transactions , Transactions[T_Date] <= Calender[Date])

)

Then using this column as values in the visualization.

Anonymous

Not applicable

6 years ago

Anonymous If it didn´t need to be dynamic to slicers that would be another option, thanks!

Forum Discussion

Filter axis but not data