Forum Discussion

k_mathana's avatar
k_mathana
Icon for Helper II rankHelper II
4 years ago
Solved

RANK on Multiple Measures with different Order

Hi there, I have a scenario that each month contractors Quoting with more than 4 options with different criteria's, some criterias values are higher the better, some criterias value are lower the be...
Need Help
  • serpiva64's avatar
    serpiva64
    4 years ago

    Hi,

    this is what i get

    using this 2 measures (RankTotal is not necessary but helps to understand)

    RankTotal by Month =
    var currentmonth = filter('Table',month('Table'[Date]))
    var Rank1 = RANKX(currentmonth,'Table'[Criteria 1],,ASC)
    var Rank2 = RANKX(currentmonth,'Table'[Criteria 2],,ASC)
    var Rank3 = RANKX(currentmonth,'Table'[Criteria 3],,DESC)
    var Rank4 = RANKX(currentmonth,'Table'[Criteria 4],,desc)
    Var RankTotal = Rank1+Rank2+Rank3+Rank4
    return
    RankTotal
     
     
    RankGlobal by Month =
    var currentmonth = filter('Table',month('Table'[Date]))
    var Rank1 = RANKX(currentmonth,'Table'[Criteria 1],,ASC)
    var Rank2 = RANKX(currentmonth,'Table'[Criteria 2],,ASC)
    var Rank3 = RANKX(currentmonth,'Table'[Criteria 3],,DESC)
    var Rank4 = RANKX(currentmonth,'Table'[Criteria 4],,desc)
    Var RankTotal = Rank1+Rank2+Rank3+Rank4
    var RankGlobal = RANKX(currentmonth,'Table'[RankTotal by Month],,Desc,Dense)
    return
    RankGlobal
     

    If this post is useful to help you to solve your issue consider giving the post a thumbs up 

     and accepting it as a solution !

k_mathana's avatar
k_mathana
Icon for Helper II rankHelper II
4 years ago

serpiva64 sorry in my exampe there were 3 contractors and each contractor has 4 options.

 

Example

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
4 years ago

Hi,

this is what i get

using this 2 measures (RankTotal is not necessary but helps to understand)

RankTotal by Month =
var currentmonth = filter('Table',month('Table'[Date]))
var Rank1 = RANKX(currentmonth,'Table'[Criteria 1],,ASC)
var Rank2 = RANKX(currentmonth,'Table'[Criteria 2],,ASC)
var Rank3 = RANKX(currentmonth,'Table'[Criteria 3],,DESC)
var Rank4 = RANKX(currentmonth,'Table'[Criteria 4],,desc)
Var RankTotal = Rank1+Rank2+Rank3+Rank4
return
RankTotal
 
 
RankGlobal by Month =
var currentmonth = filter('Table',month('Table'[Date]))
var Rank1 = RANKX(currentmonth,'Table'[Criteria 1],,ASC)
var Rank2 = RANKX(currentmonth,'Table'[Criteria 2],,ASC)
var Rank3 = RANKX(currentmonth,'Table'[Criteria 3],,DESC)
var Rank4 = RANKX(currentmonth,'Table'[Criteria 4],,desc)
Var RankTotal = Rank1+Rank2+Rank3+Rank4
var RankGlobal = RANKX(currentmonth,'Table'[RankTotal by Month],,Desc,Dense)
return
RankGlobal
 

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

  • k_mathana's avatar
    k_mathana
    Icon for Helper II rankHelper II
    4 years ago

    Hi serpiva64 Thank you so much for your time, its worked out and I understand the concept. Once again thank you so much.