Handling Stepped Matrix and Displaying values based on Current Stepped Row Level

Hi Anonymous ,

You can create two measures as below, please find the details in the attachment:

RAG = 
VAR _iniselected =
    ISINSCOPE ( 'Table'[Initiative] )
VAR _proselected =
    ISINSCOPE ( 'Table'[Program] )
VAR _inirag =
    CALCULATE (
        MAX ( 'Table'[INI.RAG] ),
        ALLEXCEPT ( 'Table', 'Table'[Initiative] )
    )
VAR _prorag =
    CALCULATE (
        MAX ( 'Table'[PGM.RAG] ),
        ALLEXCEPT ( 'Table', 'Table'[Program] )
    )
RETURN
    SWITCH ( TRUE (), _proselected, _prorag, _iniselected, _inirag )

Status = 
VAR _iniselected =
    ISINSCOPE ( 'Table'[Initiative] )
VAR _proselected =
    ISINSCOPE ( 'Table'[Program] )
VAR _inistatus =
    CALCULATE (
        MAX ( 'Table'[INI.Status] ),
        ALLEXCEPT ( 'Table', 'Table'[Initiative] )
    )
VAR _prostatus =
    CALCULATE (
        MAX ( 'Table'[PGM.Status] ),
        ALLEXCEPT ( 'Table', 'Table'[Program] )
    )
RETURN
    SWITCH ( TRUE (), _proselected, _prostatus, _iniselected, _inistatus )

Best Regards