且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

DAX移除过滤器vs全部

更新时间:2023-01-29 11:17:59

REMOVEFILTERS只是ALL的别名,因此它的工作原理相同。

REMOVEFILTERS is just an alias of ALL here, so it works just the same.

基本上,ALL返回一个包含所有行的表,而忽略任何可能

Basically, ALL returns a table including all rows, ignoring any filters that might have been applied.

但是,当ALL用作CALCULATE或CALCULATETABLE的过滤器参数时,其行为完全不同:它将删除表中的过滤器并执行n

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.

为了缓解ALL的这种混乱行为,引入了REMOVEFILTERS来代替在CALCULATE中使用ALL时。

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

有关更多详细信息,请参阅本文。
https:/ /www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/

For more details, you may look at this article. https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/