Forum Discussion
GoingIncognito
Advocate III
Advocate IIIDifference between simple sum() and sumx(daterange, sum() ) when using a time slicer
Once again seek your wisdom!
I have a simple report page with a time slicer.
I have one measure that simply states: sum(market_total_in_eur)
And another measure that states: sumx(datesbetween(Calendar[Date], firstdate(Calendar[Date]), lastdate(Calendar[Date]), sum(market_total_in_eur) ). When using the time slicer these measures return different values. Why do they return different values, when they sum over the same period?
In the pic there's the table I'm summing over. Market total can also have negative values.
You may take a look at the links below.
- https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
- https://www.sqlbi.com/articles/understanding-context-transition/
1 Reply
v-chuncz-msftCommunity Support
You may take a look at the links below.
- https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
- https://www.sqlbi.com/articles/understanding-context-transition/