How To Determine Top Ranking Sales Category for a Specific Time Period

HI Anonymous 

Try this:

Category Top =
VAR _A =
    FILTER (
        ADDCOLUMNS (
            'Sales',
            "Rank",
                RANKX (
                    'Sales',
                    CALCULATE (
                        SUM ( 'Sales'[Sales Amount] ),
                        DATESINPERIOD ( 'Sales'[DATE], TODAY (), -7, DAY )
                    ),
                    ,
                    DESC,
                    DENSE
                )
        ),
        [Rank] = 1
    )
RETURN
    MAXX ( _A, [Category] )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/