Forum Discussion
DAX CALCULATE - Using only Measure Expression with NO filter - How does it work?
rodneyc8063_1
The KEEPFILTERS(VALUES('financials'[Product])) doesn't really makes sense to me either, that one seems odd.The CALCULATE inside the iterator forces context transition so the row context (the row being interated) is converted into a filter context. Take a look at this article that discusses the topic.
https://www.sqlbi.com/articles/understanding-context-transition/
rodneyc8063_1
The KEEPFILTERS(VALUES('financials'[Product])) doesn't really makes sense to me either, that one seems odd.
The CALCULATE inside the iterator forces context transition so the row context (the row being interated) is converted into a filter context. Take a look at this article that discusses the topic.
https://www.sqlbi.com/articles/understanding-context-transition/
That use of KEEPFILTERS looked strange to me too but that usage is explained here.