Wrong total for sub categories

[DannyPhan]

I'm new to Power BI, can anyone help me fix this Measure: 

Test =

var prev_index = MAX(version_code[index])-1

var prev_ver = LOOKUPVALUE(version_code[ver], version_code[index], prev_index, "")

RETURN

CALCULATE(SUM('Version'[NC_TT_TN]), FILTER(ALLEXCEPT('Version', 'Version'[MTC]), 'Version'[Ver] = prev_ver))

BF =Before, AF = After. I want to take the results from column BF and this display them in the column AF in order to calculate the variance.

[v-zhouwen-msft]

Hi @DannyPhan ，

Can you provide .pbix files without sensitive data or simply data?

If you are unsure how to upload data please refer to

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Wenbin Zhou

[rajendraongole1]

Hi @DannyPhan - I suggest making adjustments to the prev_index logic and filtering to ensure it looks for the previous row based on your custom index logic. Please use the updated measure 

Test =
VAR current_index = MAX(version_code[index])
VAR prev_index = current_index - 1
VAR prev_ver = LOOKUPVALUE(version_code[ver], version_code[index], prev_index)
RETURN
CALCULATE(
SUM('Version'[NC_TT_TN]),
FILTER(
ALLEXCEPT('Version', 'Version'[MTC]),
'Version'[Ver] = prev_ver
)
)

Hope this works to display the expected output.

[DannyPhan]

Thanks for your answer @rajendraongole1 . But it still display the same result as before. Noted that the model has parent child hierachy.