Forum Discussion
Helper IIIRemove Report level Year filter on a single visual
cmncp - Correct. It's a bit unexpected honestly because one might think that the report and page level filters would just add filter context the way visuals on a page add filter context and thus you would be able to override that filter context within DAX. But, that is not what occurs. The report and page filters pre-filter the data that is even available to DAX when performing calculations. Efficient that way but also a bit unfortunate in circumstances such as this.
Helper IIIHi Greg_Deckler So there is no way to write a DAX measure that overrides the report level filter?
Community Championcmncp - Correct. It's a bit unexpected honestly because one might think that the report and page level filters would just add filter context the way visuals on a page add filter context and thus you would be able to override that filter context within DAX. But, that is not what occurs. The report and page filters pre-filter the data that is even available to DAX when performing calculations. Efficient that way but also a bit unfortunate in circumstances such as this.