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 !

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

Sorry, 

in your exemple there is only 1 contractor.

Can you specify your sample data? 

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.