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.
Community ChampionThis came up before. It was determined that the page filter was pre-filtering things such that DAX could not "bring back" the data by removing the filters.
cmncpHi Greg_Deckler So there is no way to write a DAX measure that overrides the report level filter?
DAX can override ANY filter and in your case, it demonstrates it clearly.
However, what you are seeing has nothing to do with DAX. Your measure removes all filters from the Calendar, so you see the sum across all the years. But you see only 3 years on the x-axis because the report-level filter puts this constraint on the Calendar and your visual queries the dimension to see which years should be shown. This has nothing to do with DAX. Your DAX removes the filter FOR THE DURATION OF THE CALCULATION correctly. Nothing more.
Best
D- Greg_Deckler
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.