Forum Discussion
Matrix Total does not filter, does not reflect what it is totaling.
I found the issue with your matrix.
It was not to do with the measures but rather with the way the relationships were setup.
You were using the Users table and a value from the MonthlyGoals table, but they were not linked together correctly. So due to this relationship not being in place the total being shown was correct based on the filter context (because there was no filtering being applied between the Users table and the MonthlyGoals table)
So what I did to resolve this was to change the Cross Filter direction on the Customer table to the Territory Table to be Both.
And now the total displays correctly.
I also put in another measure called Correct Total if you were wanting to have a different measure based on the Row Context.
You can find the uploaded file here: https://1drv.ms/u/s!Apxn-69XhcAmhqhy5yutRFAH92ID6Q
I found the issue with your matrix.
It was not to do with the measures but rather with the way the relationships were setup.
You were using the Users table and a value from the MonthlyGoals table, but they were not linked together correctly. So due to this relationship not being in place the total being shown was correct based on the filter context (because there was no filtering being applied between the Users table and the MonthlyGoals table)
So what I did to resolve this was to change the Cross Filter direction on the Customer table to the Territory Table to be Both.
And now the total displays correctly.
I also put in another measure called Correct Total if you were wanting to have a different measure based on the Row Context.
You can find the uploaded file here: https://1drv.ms/u/s!Apxn-69XhcAmhqhy5yutRFAH92ID6Q
Hi Guys,
I''ve the same issue.. How can I make a measure based on row contex ? I need to show the total, which it hasn't to change when I filtered on a dimension.
Thanks
Alice