Measure returning correct total but row value is incorrect

Hi otto-user101 ,

Based on the example and description you provided, please try code as below to create measure.

Min = 
VAR _mintyear =
    MINX ( ALLSELECTED('Table'),'Table'[Year] )
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Primary Key] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Region] = MAX ( 'Table'[Region] )
                && 'Table'[Year] = _mintyear
        )
    )
RETURN
    IF ( _count = BLANK (), 0, _count )

Min_Result = 
IF (
    HASONEVALUE ( 'Table'[Region] ),
    [Min],
    SUMX ( VALUES ( 'Table'[Region] ), [Min] )
)

Max = 
VAR _maxyear =
    MAXX ( ALLSELECTED('Table'),'Table'[Year] )
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Primary Key] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Region] = MAX ( 'Table'[Region] )
                && 'Table'[Year] = _maxyear
        )
    )
RETURN
    IF ( _count = BLANK (), 0, _count )

Max_Result = 
IF (
    HASONEVALUE ( 'Table'[Region] ),
    [Max],
    SUMX ( VALUES ( 'Table'[Region] ), [Max] )
)

When the slicer is set to 2020-2022, Result is as below.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi v-weiyan1-msft thanks for your response. The dax you provided for Min (and Max) populates 0 when the count is blank. 

There's something I didn't include in my initial post - the regions are grouped and with the new dax, the subtotals and totals are inaccurate, and I'm looking to achieve what's shown in the table below. 

Can you assist with this? Much appreciated!