Table Total Not Summing Correctly

Question

Hello,I know this is a very common error and I am not sure why I can't seem to wrap my head around such a simple error. Please see the below image as the last column is not summing correctly.&nbsp;&nbsp;Now my measures are as follows, for the column Total Borrowing:Total Borrowing =Var Oustanding =CALCULATE(SUM(Table'[Amount]),Table'[TransactionType] = "Outstanding")&nbsp;Var QBOutstanding =CALCULATE(SUM(Table'[Amount]),Table'[TransactionType] = "QBOutstanding")ReturnOutstanding + QBOutstanding&nbsp;Now the Bank Percentage of Fund measure is:BankPercentage =Var SelectedBank = SelectedValue(Bank List'[Bank Name])Var BankPercentage = Calculate(MAX(Bank Data'[Bank %]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bank Data'[Bank] = SelectedBank&nbsp;Then for the final column the measure is:Total Borrowing * Bank Percentage&nbsp;Now the thing is that it is showing the correct results by row, but it isn't showing the correct total at the bottom of the column. I understand that it is taking the max percentage, hence why it is multiplying the 100% bank rate to the borrowing which provides the 1.2 Billion number. My thing is how do I get to multiply by row and then show that.&nbsp;&nbsp;If I can be more clear, please just let me know.

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Please try this:
First of all, I create a set of sample:

Then add 2 measures:
Measure1 = MAX('Table'[percentage])Measure 2 = SUM('Table'[Total Sales])
Then I create measure3:
Measure 3 = SUMX('Table',[Measure1]*[Measure 2])
The result is as follow, the total could be correct:

If the above one can't help you, could you please provide more&nbsp;raw data&nbsp;in your tables (exclude&nbsp;sensitive&nbsp;data) with&nbsp;Text&nbsp;format and your&nbsp;expected result&nbsp;with backend logic and special examples?&nbsp;It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And&nbsp;It is better&nbsp;if you can share a&nbsp;simplified&nbsp;pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Zhengdong XuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Related content

Negative values not be summed correctly

table doesnt sum correctly

Table not calculating sum correctly

Grand Total Not Summing Correctly

Summing the max values correctly