Forum Discussion
Solved
DAX CALCULATE - Using only Measure Expression with NO filter - How does it work?
So I have been trying to learn/study Power BI and "thought" I had a good decent grasp on DAX and CALCULATE that is UNTIL I came across a sample question that totally threw me for a loop. I am goi...
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/
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 😞