cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ppatris Frequent Visitor
Frequent Visitor

Rank by Quarters

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.rank.PNG

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])))))

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Rank by Quarters

HI @ppatris,

 

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

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



For learning resources/Release notes, please visit: | |
3 REPLIES 3
Super User
Super User

Re: Rank by Quarters

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Community Support Team
Community Support Team

Re: Rank by Quarters

HI @ppatris,

 

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

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



For learning resources/Release notes, please visit: | |
ppatris Frequent Visitor
Frequent Visitor

Re: Rank by Quarters

Hi Xiaoxin Sheng,

 

Thank you for that is very helpful!

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 255 members 2,810 guests
Please welcome our newest community members: