Why doesn't removefilters have any affect?

[mp390988]

Hi,

I created this measure:

I trying to understand why this measure without the REMOVEFILTERS yields the same result as that with REMOVEFILTERS?

For example, in Jan the networkdays is 22 both with REMOVEFILTERS and without REMOVEFITLERS.

I thought REMOVEFILTERS will remove all the filters coming from the visual.

I have 8 holidays in my table throughout 2025.

[v-tsaipranay]

Hi @mp390988 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-tsaipranay]

Hi @mp390988 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-tsaipranay · Accepted solution]

Hi @mp390988 ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

The reason you're seeing the same result with or without REMOVEFILTERS() is because it's only applied to the holiday list inside CALCULATETABLE, not to the overall date range used by FIRSTDATE() and LASTDATE().

So even with REMOVEFILTERS(), the measure still calculates network days within the visual’s current context (e.g., Jan, Feb), but excludes holidays from the full year, since filters on the holiday column are cleared.

In your case, if a month has no holidays, the result remains unchanged which is expected.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

[v-tsaipranay]

Hi @mp390988 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.