REMOVEFILTERS not working for me

[Sperling]

I have a report page where I have 3 filters:

Reporting Date is in Current Month

Reported in Future = No

Reported Today = No

I want to make a measure that counts the Reporting Days in the month (Working days) - ignoring the two "No" filters.

This is for another measure, but I've just isolated the measure to find a solution.

My measure right now is:

    CALCULATE(

        COUNTROWS('Reporting Date'),

        FILTER(

            'Reporting Date',

            NOT ('Reporting Date'[Reporting Weekday]) IN {"Saturday", "Sunday"}

        ),

        REMOVEFILTERS(

            'Reporting Date'[Reported In Future?],

            'Reporting Date'[Reported Today?]

        )  

    )

However, this doesn't remove the filters.

As of today (2023-10-03) it returns a value of 1, which should be 22.

If I remove the two "No" filters from the page it returns the right value of 22.

Any ideas?

[Anonymous]

Hi @Sperling ,

I have made a sample with REMOVEFILTERS() on myside. It works on myside. It will remove the filters from slicer or filters in filter pane. I think your issue should be caused by your data model. Please share a sample file with me and show me a screenshot with the result you want. This will make it easier for us to find the solution.

Best Regards,
Rico Zhou

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

[AntrikshSharma]

@Sperling CALCULATE evaluates FILTER arguments before CALCULATE modifiers such as REMOVEFILTERS, Reporting Date inside FILTER function already gets filtered before REMOVEFILTERS and then REMOVEFILTERS is applied after which the table returned by FILTER is applied to the filter context. 

Use this instead

CALCULATE(
    COUNTROWS('Reporting Date'),
    NOT 'Reporting Date'[Reporting Weekday] IN {"Saturday", "Sunday"},
    REMOVEFILTERS(
        'Reporting Date'[Reported In Future?],
        'Reporting Date'[Reported Today?]
    )  
)

[Sperling]

Hi Antriksh,

Unfortunately this measure doesn't work either.

Here's a screenshot of my test PBI file and DaysInMonth is the measure I'm testing out.

[Dangar332]

Hi, @Sperling 

You can use edit interaction to avoide slicer effect on your visuals 

for more about edit interaction please refer these video.

and yah! here you use 

REMOVEFILTERS(

            'Reporting Date'[Reported In Future?],

            'Reporting Date'[Reported Today?]

        )  

as a filter modifier in calculate so it not remove filter it only remove filter context.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Sperling]

Hi Dangar,

Thanks for your reply.

Unfortunately the filters are not in the report itself in a slicer, but added as a filter.

It's a KPI report, so I don't want them present in the view - I could do that and hide them, but I don't think it's a great solution down the line in case someone has to take over.

I tried using ALL() also, but I'm not having luck getting it to work. For example, this also returns a value of 1 (final solution should also remove the "Reported Today" filter, but just tested without it):

    CALCULATE(

        COUNTROWS('Reporting Date'),

        FILTER(

            'Reporting Date',

            NOT ('Reporting Date'[Reporting Weekday]) IN {"Saturday", "Sunday"}

        ),

        ALL(

            'Reporting Date'[Reported In Future?]

        )

    )

[Dangar332]

hi, @Sperling 

var table1 = calculatetable(all(

'Reporting Date'[Reported In Future?],

            'Reporting Date'[Reported Today?] ))

return

    CALCULATE(

        COUNTROWS(table1),

        FILTER(

            'Reporting Date',

            NOT ('Reporting Date'[Reporting Weekday]) IN {"Saturday", "Sunday"}

        )

    )

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Sperling]

Hi again,

Seems that this approach also counts the first sunday?

It rightfully counts today since it ignores the page filter of reported today, but still doesn't ignore reported in future.

So confusing.

I'll look into creating a file with sample data, but its a traditional date dimension

[Dangar332]

hi, @Sperling  if its not working then provide some sample date without confidential information