DAX Adding up ranks over another grouping

Yikester20

Try to create a measure as below. See more details in the attached pbix file.

Overall Rank =
VAR tbl =
    ADDCOLUMNS (
        sales,
        "rank", RANKX (
            CALCULATETABLE ( sales, ALLEXCEPT ( sales, sales[Week/End] ) ),
            sales[Sales],
            ,
            DESC,
            DENSE
        )
    )
RETURN
    SUMX ( tbl, [rank] )