Hierarchy level logic

glycine76 ,

There are many ways... You can try this:

FinalStatus = 
VAR t = 
    ADDCOLUMNS (
        DISTINCT ( Table[Level 1] ),
        "approved",
            VAR c_level = CALCULATE ( SELECTEDVALUE ( Table[Level 1] ) )
            VAR level1count = CALCULATE ( COUNT ( Table[Level 1] ), Table[Level 1] = c_level )
            VAR statusCount = CALCULATE ( COUNT ( Table[Status] ), Table[Status] = "Approved" )
            RETURN
                IF ( INT ( statusCount = level1count ) = 1, 1, BLANK () )
    )
RETURN
SUMX ( t, [approved] )