Forum Discussion
Totals Column values does not display correct values.
Hi there,
New to Power BI but I am having a lot of trouble with this problem. Been researching and looking at other similar questions but I still can't resolve the issue.
Can anyone tell me why the Totals Platform MRR isn't adding up the total of the row?
Figures should read: £1200, £300, £300, £300, £300 respectively from top to bottom in this columns.
Any help greatly appreciated. Thanks in advance.
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
8 Replies
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
