REMOVEFILTERS/ALLEXCEPT not removing page level and report level filters

[afernand0]

Hi,

I have a measure (2 variants) as below to calculate the sum of a column for all calendar periods. 

Measure = 
CALCULATE(
SUM('FACT ATS'[Planned Quantity Basic Units]),
ALLEXCEPT('DIM Bega Calendar', 'DIM Bega Calendar'[Fiscal Period]))

Measure = 
CALCULATE(
SUM('FACT ATS'[Planned Quantity Basic Units]),
REMOVEFILTERS('DIM Bega Calendar'[REL MTD/LM/NM/MTD YAGO/LM YAGO]))

And I have a page level filter applied to the [REL MTD/LM/NM/MTD YAGO/LM YAGO]

column of the calendar table to select the current period (202309). And I'm trying to display a table with the sum for all periods. However, the measure below is not removing the period filter and shows data only for the current period. What am I doing wrong here?

[johnt75]

I have a couple of thoughts.

Which column from the date table are you using in the visual? You would need to remove filters from that too.

If you are using the same column which you are removing filters from, is that column sorted by a different column? If so, you will need to remove filters from the sort by column as well as the main column.