Forum Discussion
Data from a indirect relationship.
I managed to solve the issue doing the following:
I created a measure that sums up the Rate
ValueSumRate = SUM(Rates[Rate])
And then I proceeded to SumX that value by its lowest possible level, being User
UserCost = SUMX(User,[ValueSumRate])
Now regardless of how I display the value it always calculates the rates based on the lowest possible value.
Hi v-yulgu-msft
I have, tried that, I want to display it on a higher level than user though.
I tried using a matrix rather than a table, putting in user hoping it would display on a branch level with user level data, then I can just drill it up so that the users don't display but only the branch, but it does the following:
The highlighted total doesn't show the sum of the values below it :/