topic Re: RemoveFilters not working as expected in DAX Commands and Tips

RemoveFilters not working as expected

astano05 — Fri, 09 Feb 2024 14:00:17 GMT

I have a page level filter for DaysAgo>0. This allows my MTD LY /YTD LY time calculation filters to work as expected and not go through the full month of the previous year.

I am now also trying to build a measure for the full previous month of the current year, but this filter prevents it from looking past the current day (for example, it's 2/9/24 and I want full month of January, but the DAysAgo filter only shows to 1/9/24).

Does RemoveFilters not work on page level filter context? Is there another way to accomplish this?

Net Sales PrevMonth = CALCULATE([Net Sales MTD],DATEADD('Calendar'[Date Value],-1,MONTH),REMOVEFILTERS('Calendar'[Days Ago]))

Re: RemoveFilters not working as expected

lbendlin — Sat, 10 Feb 2024 01:27:47 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: RemoveFilters not working as expected

astano05 — Wed, 14 Feb 2024 14:38:34 GMT

I'm not able to provide data in that way due to company policy.

Is there any reason why removefilters would not work on a page-level filter?

Re: RemoveFilters not working as expected

lbendlin — Wed, 14 Feb 2024 15:03:01 GMT

Sorry, I only work with sample data. I hope someone else can help you further.

Re: RemoveFilters not working as expected

Anonymous — Fri, 23 Feb 2024 09:21:30 GMT

Hi astano05

Given your scenario, where you have a page-level filter for “DaysAgo > 0” and you're attempting to calculate “Net Sales PrevMonth” for the full previous month, your approach seems logically sound.

The issue might stem from how the filter context is passed down or from the specific interactions between your measures and the data model.

You might try the following:

Verify relationships: Make sure the relationships between the Calendar table and other related tables in the data model are set up correctly.

If "REMOVEFILTERS" does not provide the expected results, consider using an alternative to explicitly define the calculated date range.

For example, you can use the combination of "FILTER" and "ALL" to redefine the context of a calculation:

Last month’s net sales = calculate( sum('yourTable'[Net Sales MTD]), filter( all('calendar'), 'Calendar'[date value] > EOMONTH(TODAY(), -2) && 'Calendar'[date value] <= EOMONTH(TODAY(), -1) ) )

This metric explicitly sets the date range to the entire month of the previous month, regardless of current day or any page-level filters.

Regards,

Nono Chen

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

Re: RemoveFilters not working as expected

astano05 — Fri, 23 Feb 2024 13:49:22 GMT

I was actually able to get my measure working by using ParallelPeriod in place of DateAdd. The RemoveFilters context was no longer needed with that.

Thank you