Forum Discussion
Ignoring filter within DAX using multiple filters
Hi all, I'd like to show the current year values regardless of the selected year in the filter pane. Here's my code: FCosts_YTD = CALCULATE( SUM(PERFORMANCE[VALUE_2]) ...
Anonymous
You may take a look at the article below.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
For such a scenario, move year to a different table and join it back with your table.
FCosts_YTD =
CALCULATE(
SUM(PERFORMANCE[VALUE_2])
;FILTER(ALL(YEAR);YEAR[YEAR]=[Actual_Year])
;FILTER(PERFORMANCE;PERFORMANCE[ENTRY_TYPE]="REAL")
;FILTER(PERFORMANCE;PERFORMANCE[TYPE]="FCOST")
)