Forum Discussion
bouyazbekj
Helper I
7 years agoTotal column not changing with filters
Hello, I need help trying to figure out why my "Total" column keeps showing 6,250,843 despite adding a filter for the approver. What I need is the total to change to the the amount that applies t...
Greg_Deckler
Community Champion
7 years agoWhen a measure executes in a Total row, it always executes in the context of ALL. It removes all context filters. So, that is why it never changes. When you filter the table, the rows change but the context in the Total row is still ALL so you have to account for that. The last link I sent shows how to fix it.
bouyazbekj
Helper I
7 years ago- bouyazbekj7 years ago
Helper I
Bump. Still looking for help
- v-danhe-msft7 years ago
Microsoft Employee