Removefilters not working with Date Hierarchy

[Coens]

Hi all,

Newbie at Power BI here, sorry if my question doesnt make much sense...

I have a measure that calculates/stores the lowest price paid for a product throughout time. For this I use REMOVEFILTERS on my invoice dates. 

I have a matrix in which the invoice dates are the colums, this works fine, but as I have many invoice dates, I want to use date hierachy. When I select date hierarchy however, the REMOVEFILTERS does not seem to work--> the lowest price paid is then the lowest price in a year/month.

Hope this question makes sense? And I hope someone knows what I can do to solve this. 

Thanks a bunch! 

Coen

[v-eqin-msft]

Hi @Coens ,

Could you tell me if my post helps you? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft · Accepted solution]

Hi @Coens ,

Firstly glad to know your original issue has been solved by yourself. So now your question is the differences between ALLEXCEPT() and REMOVEFILTERS(), right?

To my knowledge,ALLEXCEPT is mostly used along with CALCULATE to remove all filters from a table, except for some columns.

And sometimes ,REMOVEFILTERS is just an alias of ALL , so it works just the same.Basically, ALL returns a table including all rows, ignoring any filters that might have been applied.

However, when ALL is used as a filter argument of CALCULATE or CALCULATETABLE, it behave totally differently: it removes filters from the table and does not return a table.

To alleviate this confusing behavior of ALL, REMOVEFILTERS was introduced to replace ALL when it is used inside CALCULATE.

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

[Coens]

Well I kinda have it solved by using ALLEXCEPT instead of REMOVEFILTERS but it's still weird behaviour no?