cancel
Showing results for
Did you mean:
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.

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

## 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

## 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

Proud to be a Datanaut!

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: | |
Frequent Visitor

## Re: Rank by Quarters

Hi Xiaoxin Sheng,

Thank you for that is very helpful!

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 255 members 2,810 guests
Recent signins: