March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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.
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
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.
Well I kinda have it solved by using ALLEXCEPT instead of REMOVEFILTERS but it's still weird behaviour no?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
88 | |
78 | |
65 | |
59 |
User | Count |
---|---|
140 | |
122 | |
105 | |
94 | |
90 |