Forum Discussion
DannyPhan
1 year agoNew Member
Wrong total for sub categories
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, "") ...
rajendraongole1
Super User
1 year agoHi 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
1 year agoNew Member
Thanks for your answer rajendraongole1 . But it still display the same result as before. Noted that the model has parent child hierachy.