REMOVEFILTER works for all, except one specific subset

[yannis_tnp]

I have a Measure that counts the rows of a column and removes the filter of another column.

The Measure looks like this:

Total_Sales = CALCULATE(

    COUNT(Query1[Sale_Number]);

    REMOVEFILTERS(Query1[Months_Until_Return])

)

To clarify:

- The 'Total_Sales' for September for the product 'PAPER' is 40.
- The 'Total_Sales' for all products is 6895.

I created a card to display the 'Total_Sales' for each product. Even if I include the 'Months_Until_Return' filter, the 'Total_Sales' should remain unchanged due to the REMOVEFILTERS function in the Measure. However, for the product 'PAPER', the value returned is 23 instead of 40.

For example:

while for other products the value remains unchanged:

and the total (when nothing is selected) is correct:

Is it a PowerBI issue or am I missing something?

Thank you very much for your help.

[v-tianyich-msft]

Hi @yannis_tnp ,

I did some testing and failed to reproduce your problem, please provide your sample data.Please check if your first case is applying a page level filter.
Use Weeknum:

Use Month:

Best regards,
Community Support Team_ Scott Chang