Total error when Retrieve the last available value from a table.

Hi Ezzeldin 

Check enclosed file. I created two measures as below.

I check for two GL ID's as shown on picture below

if gives me an error.

Ezzeldin this is known bug. Dont worry, check results

Unfortunately, the result is still incorrect.

Hi Ezzeldin give me example of wrong and one example of correct /expected output based on enclosed file

hi some_bih ,

Based on the screenshot provided, I tested GL 102122. When I selected Year 2023 and Month 1 for Company Code 1000, the expected result was 200,000,000. Similarly, for Company Code 2000, the expected result was 300,000,000. The total amount was expected to be 500,000,000.

Hi Ezzeldin 

I filtered out only GL 102122 below how to get 200 000 for January 2023. Mark rows

200,000,000 is the last available value for GL: 102122 in company code: 1000 when we choose Year: 2023 and Month: 1.
if we choose Year: 2022 and Month: 2 the last available value for GL: 102122 in company code: 1000 is:165,000,000

same for company code: 2000 when we choose Year: 2023 and Month: 1 the result for GL: 102122 should be: 300,000,000 which is the last available value before the last date of the selected month as my measure dose.
the problem with my measure is with the totals.