Incorrect total value in the table or matrix however values are matching in excel

[Anonymous]

Hello,

I don't understand what kind of magic it is when I up the table, grand total isn't appropriately calculated however its still matches the excel grand total & now I suspect the subtotals aren't correct,
Please help me find the solution
Table I Got in Power Bi

Excel sheet 

Tables: Table 1 & Table 2 established relationship through both ways combined code

I look forward to it 

[Anonymous · Accepted solution]

Hi @Anonymous ,

I suggest you to create a measure by SUMX() based on [new_originalbudget202223] and [count] measure.

new_originalbudget202223 = SUM('TableName'[Original Budget 2022/23])

Count of new_originalbudget202223 = COUNT('TableName'[Original Budget 2022/23])

New Measure:

Measure1 = SUMX(VALUES('TableName'[Month]),[new_originalbudget202223])

Measure2 = SUMX(VALUES('TableName'[Month]),[Count of new_originalbudget202223])

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.