Sum of measure out of opening balance aren't correct

[AndrejZitnay]

Hello all,

Would you be so kind and help me out with measures that comes out of opening balance?

Sum of measure out of opening balance aren't correct

Sum of Measure 1 is showing in PBI 28.20 however it should be 35.00

Sum of Measure 2 is showing in PBI 57,750.00 however it should be 72,916.67

Sum of Measure 3 is showing in PBI 3,525.00 however it should be 4,375

MonthlyNew = SUMX('Table 1','Table 1'[Monthly New])

Deduction 1 = SUMX('Table 2','Table 2'[Deduction 1])*-1

Deduction 2 = SUMX('Table 3','Table 3'[Deduction 2])*-1

Deduction 3 = SUMX('Table 3','Table 3'[Deduction 3])*-1

Deduction 4 = SUMX('Table 3','Table 3'[Deduction 4])*-1

Balance = [MonthlyNew]+[Deduction 1]+[Deduction 2]+[Deduction 3]+[Deduction 4]

OpeningBalance = CALCULATE(SUMX(VALUES(MonthTable[Month]),

[Balance]),FILTER(ALLSELECTED(MonthTable),MonthTable[Month]<=EOMONTH(MAX(MonthTable[Month]),-1)))

Closingbalance = CALCULATE([Balance],FILTER(ALLSELECTED(MonthTable),MonthTable[Month]<=MAX(MonthTable[Month])))

Opening Balance + Monthly new = [OpeningBalance]+[MonthlyNew]

Measure 1 = [Opening Balance + Monthly new]/10

Measure 2 = ([Measure 1]*25000)/12

Measure 3 = [Measure 2]*0.06

Here is my pbix : https://ulozto.cz/tamhle/09aKv8imMdia/name/Nahrano-17-2-2021-v-16-26-19

Many thanks in advance.

Kind regards.

Andrej

[v-rzhou-msft · Accepted solution]

Hi @AndrejZitnay 

Try to build three new measures as below.

New_Measure1 = SUMX(MonthTable,[Measure 1])

New_Measure2 = SUMX(MonthTable,[Measure 2])

New_Measure3 = SUMX(MonthTable,[Measure 3])

Result is as below.

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. 

[AndrejZitnay]

Hello @v-rzhou-msft ,

Thank you very much!!!!

Andrej