Select an specific value from a filtered table

Hey Patricio479 ,
if this is your target result:

you can try to apply this formula into your model. Should work for your described purpose.

MAX Value = 
    CALCULATE(
        MAX(yout_table[Number]),
        'Calendar'[Date] = MAX(your_table[Date])
        )

Regards

Patricio479 Ok, let's test it, if it doesn't work then I will recreate dataset on my end to test it:

Measure = 
CALCULATE (
    MAX ( Table[Number] ),
    INDEX (
        1, 
        SUMMARIZE ( ALLSELECTED ( Table ), Table[Date], Table[Division] ),
        ORDERBY ( Table[Date], DESC ),
        PARTITIONBY ( Table[Division] )
    )
)