Rank by Quarters

[Anonymous]

Dear All,

I have a question, I am trying to rank some values by time what I want is to rank by month and by quarter.

I use the below formula. The problem is that I dont get the rank by quarters

Rankq = RankX(ALLSELECTED('Date'[Month/Yeart].[Date]); Calculate(SUM((('data-Table'[Amount])))))

[v-shex-msft · Accepted solution]

HI @Anonymous,

I'm not so sure for your scenario, can you please share some sample data for test? If you mean ranking by multiple columns, you can try to use following measure:

Measure 2 =
VAR summary =
    SUMMARIZE (
        ALLSELECTED ( 'Calendar' ),
        [Year],
        [Quarter],
        [Month],
        "Total", SUM ( 'Calendar'[Amount] )
    )
RETURN
    COUNTROWS (
        FILTER (
            summary,
            ISONORAFTER (
                    [Year], SELECTEDVALUE ( 'Calendar'[Year] ), DESC,
                    [Quarter], SELECTEDVALUE ( 'Calendar'[Quarter] ), DESC,
                    [Month], SELECTEDVALUE ( 'Calendar'[Month] ), DESC
            )
        )
    )

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Xiaoxin Sheng,

Thank you for that is very helpful!

[Greg_Deckler]

Can you post some text sample data to work with? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490