Forum Discussion
Problem with Row context
Good to hear. What I learned from this is that only the first expression of the Calculate() is impacted by the context transition. That was not clear to me before.
SELECTEDVALUE() expects a single value in the filter context. You don't have that in a group.
I realize that SelectedValue takes a single value, but it is in a Sumx, the below DAX is closer to the real formula that I'm using. You can see that the SelectedValue is still valid because it is part of the SumX iterator.
Did you know that you can pack variables inside the sumx ?
sumx(
var a=selectedvalue(b)return caclulate()
)
etc.
No I did not know that, but even when I change it to using variable I get the same results.
You didn't show how you changed it. What I am trying to point out is that the moment you use CALCULATE(), SELECTEDVALUE takes on a new meaning, one that you might not intend.
https://www.sqlbi.com/articles/context-transition-and-filters-in-calculate/