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 w...
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