Alberto Ferrari
sqlbi.com
Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.
SQLBits 2020
Should you use bidirectional filters in Tabular?
The quick answer is no, you should not. As with any rule, there are exceptions.
When used with care, bidirectional filters are a powerful weapon in the hands of a skilled data modeller.
The quick answer is no, you should not. As with any rule, there are exceptions.
Indeed, when used with care, bidirectional filters are a powerful weapon in the hands of a skilled data modeller. In this quick talk Alberto analyzes the reasons why bidirectional filters are dangerous, and he provides some insights on why and when it is safe to use bidirectional filters.