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.
Ah, very nice. Count on the Italians to have covered the topic!
Thanks jdbuchanan71 and AlexisOlson - This is super helpful!
But also looks like I have quite a bit of homework this weekend to read over 😞
