How to remove filters that have been applied to one table, but retain all other filters?

[Anonymous]

In my report, the users can slice by the dimDate dimension. They can slice by Year, Month, Week, Day, IsWorkingDay, IsMonthEnd, and any combinations of these. They can also slice by other dimensions.

I am writing a measure from a fact table, and I would like to remove all the filters that have been applied to the dimDate dimension (so the measure can look at data from rows from any date), but I want to retain all other filters selected on any other dimension (e.g. I want any selected Accounts, Teams, Departments, Countries, etc to remain in place.)

How do I achieve this?

[Greg_Deckler]

@Anonymous - Can you share the measure formula you are trying to create (jist of it). The specific solution may vary depending on exactly what you are trying to do. If you can share PBIX or sample data to recreate that would be good as well. In general you can use REMOVEFILTERS to get rid of offensive filters or you can use ALL or ALLEXCEPT to also override or change filter context.

[Anonymous]

Ok. So the meaning of the function ALL(table) is

From the current context, remove every filter from from every field in table, but retain all other filters.

[v-deddai1-msft]

Hi @Anonymous ，

Yes，using removefilters function will become more intuitive in your formula. Please refer to https://docs.microsoft.com/en-us/dax/removefilters-function-dax 

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

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , One of three method -

calculate(Sum(Table[value]), removefilters(DateTable))
calculate(Sum(Table[value]), all(DateTable))
calculate(Sum(Table[value]), ALLCROSSFILTERED(DateTable))

refer: https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

[camargos88 · Accepted solution]

Hi @Anonymous ,

You can create a measure like:

CALCULATE(SUM(TABLE[ABC])), ALL(D_DATE))