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
Hi Anonymous ,
What is your Platform MRR? A column or a measure?
If it is a measure, please share your measure formula.
If that is a column, please share your data sample which could reproduce your scenario so that we could help further on it?
Best Regards,
Cherry
Hi v-piga-msft ,
It is a calculated column.
| Client | Client Location | Fee |
| Client | Client 1 | £100.00 |
| Client | Client 2 | £100.00 |
| Client | Client 3 | £100.00 |
| Client | Client 4 | £100.00 |
Hi Anonymous
I would suggest to share a sample pbix where you can add some sample data of your table and also create the same visual. This will help resolving your issue faster.
Regards
Affan
Hi affan
Please follow this link:
https://github.com/PythoNiko/Power_BI/blob/master/TotalsProblem.pbix?raw=true
Hope this is of more use to anyone who can help.
Thanks!
Bump.
Can anyone shed any light on this issue please?
