Filter items which are not max id

Greg_Deckler thank you for the answer, I get the point and modified a little the formula to get what I want:

Distribution Max Measure= 
var _sum =
SUMX(VALUES( fact_table[region_id] ), LASTNONBLANKVALUE(fact_table[visit_id],
        SUM(fact_table[distribution_flag])))
var _count =
SUMX(VALUES( fact_table[region_id] ), LASTNONBLANKVALUE(fact_table[visit_id],
        COUNTROWS(fact_table)))
VAR __Table = ALLSELECTED('fact_table')
VAR __Max = CALCULATE (
        MAX ( 'fact_table'[visit_id] ),
        FILTER (
            ALLSELECTED ( 'fact_table' ),
            'fact_table'[region_id] = SELECTEDVALUE ( 'fact_table'[region_id] )
        )
    )
VAR __Current = MAX('fact_table'[visit_id])

RETURN
   IF(__Current = __Max, var _sum / _count, BLANK())

 but for some reason this measure is not aggregating properly:

It works fine when visit_id field is added to the table, but the point is not to show visit_id and period.

Now when I choose for example periods 2021P1 to 2021P11:

Right now for prod_3 it shows 0%, but the visit_id and period will not be shown in the table, so the result should be:

Could you please help me with this?