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])))))
Go to Solution.
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 =
ALLSELECTED ( 'Calendar' ),
"Total", SUM ( 'Calendar'[Amount] )
[Year], SELECTEDVALUE ( 'Calendar'[Year] ), DESC,
[Quarter], SELECTEDVALUE ( 'Calendar'[Quarter] ), DESC,
[Month], SELECTEDVALUE ( 'Calendar'[Month] ), DESC
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!
Hi Xiaoxin Sheng,
Thank you for that is very helpful!
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!