Rank using multiple attribute columns and 1 value column

Hi Anonymous 

Create a calcualted column,

month-year = FORMAT([Day],"Mmmm YYYY")

Then create two measures

sum =
CALCULATE (
    SUM ( 'Table 3'[Value] ),
    FILTER (
        ALLSELECTED ( 'Table 3' ),
        'Table 3'[Name] = MAX ( 'Table 3'[Name] )
            && 'Table 3'[month-year] = MAX ( 'Table 3'[month-year] )
            && 'Table 3'[Group] = MAX ( 'Table 3'[Group] )
    )
)

rank =
RANKX (
    FILTER (
        ALLSELECTED ( 'Table 3' ),
        'Table 3'[month-year] = MAX ( 'Table 3'[month-year] )
            && 'Table 3'[Name] = MAX ( 'Table 3'[Name] )
    ),
    [sum],
    ,
    DESC,
    DENSE
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.