Forum Discussion

sjpathak's avatar
sjpathak
Frequent Visitor
8 years ago

Ignore report level filter in a measure

I've read numerous posts about this, it still doesn't works for me. My scenario is as below -   I have a Date dimension (DimDate) and a Fact (StockAvailability). There are several visuals on the pa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

This is likely what you are trying to write  (i've assumed you have and use a date table):

Overall Stock Availability = 
CALCULATE(
	AVERAGE([Availability], 
	DATESINPERIOD(
		'Date Table'[Date], 
		LASTDATE('Date Table'[Date]), 
		-3, 
		MONTH
	)
)

 

If that doesn't work, you might need to make the AVERAGE line its own measure and try this:

Availability Average = AVERAGE([Availability])
Overall Stock Availability = 
CALCULATE(
	[Availability Average], 
	DATESINPERIOD(
		'Date Table'[Date], 
		LASTDATE('Date Table'[Date]), 
		-3, 
		MONTH
	)
)

 

sjpathak's avatar
sjpathak
Frequent Visitor
8 years ago

Unfortunately, with both the above, I get the same result, its limited to 7 days only due to the report level filter.