Forum Discussion
Totals Column values does not display correct values.
Hi Anonymous ，
By my research from your sample pbix, I'm afraid that the subtotal in the matrix shows the correct values based on logic.
As we can see from your data model, the fee has no relationship of Month, the sum of fee Client1 is 100 so that subtotal in matrix is 100.
If you want to show 400 in the row subtoal, you need to create a calcualted column in Performance table and then you could create the desired matrix.
Column = LOOKUPVALUE('Clients'[Fee],Clients[Client Location],'Performance'[Client Name])Here is the output.
Hope this is clear.
Best Regards,
Cherry
Bump.
Can anyone shed any light on this issue please?
Resident RockstarHi Anonymous ，
By my research from your sample pbix, I'm afraid that the subtotal in the matrix shows the correct values based on logic.
As we can see from your data model, the fee has no relationship of Month, the sum of fee Client1 is 100 so that subtotal in matrix is 100.
If you want to show 400 in the row subtoal, you need to create a calcualted column in Performance table and then you could create the desired matrix.
Column = LOOKUPVALUE('Clients'[Fee],Clients[Client Location],'Performance'[Client Name])
Here is the output.
Hope this is clear.
Best Regards,
Cherry