Matrix Row Subtotal for Text as the most frequent values, instead of "First"

Hi Renna ,

You can create a measure as below and replace the field [Project Manager] with this new measure.

MProjectManager =
VAR MaxCount =
    MAXX (
        VALUES ( 'Table'[Project Manager] ),
        CALCULATE ( COUNT ( 'Table'[Project Manager] ) )
    )
VAR PMList =
    CONCATENATEX (
        FILTER (
            VALUES ( 'Table'[Project Manager] ),
            CALCULATE ( COUNT ( 'Table'[Project Manager] ) ) = MaxCount
        ),
        'Table'[Project Manager],
        ", "
    )
VAR ProjectTypeTable =
    SUMMARIZE (
        'Table',
        'Table'[Project Types],
        'Table'[Project ID],
        'Table'[Project Manager]
    )
VAR ModeValue =
    TOPN (
        1,
        ADDCOLUMNS (
            ProjectTypeTable,
            "SRevenue",
                CALCULATE (
                    SUM ( 'Table'[Revenue] ),
                    ALLEXCEPT (
                        'Table',
                        'Table'[Project Manager],
                        'Table'[Project ID],
                        'Table'[Project Types]
                    )
                )
        ),
        [SRevenue], DESC
    )
RETURN
    IF (
        IFERROR ( SEARCH ( ",", PMList, 1, 0 ), 0 ) > 0,
        MAXX ( ModeValue, [Project Manager] ),
        PMList
    )

Best Regards

pls try this