Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Max Rank

i've got a ranking Measure that is going onto a guage tile.  Getting the rank works great but in order to make my guage as meaningful as possible, i need to calculate what the Max Ranking is.  This w...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Coming back to this fresh i've come up with the solution.  Here is what worked:

     

    Graph Gauge Min = maxx(
	values('Dim - RegionNames'[RegionName]), 
	[EBIT Per FTE]
)
DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

Hi Anonymous

 

I assume your rank is a calculated column in your table that looks similar to this one:

 

This measure calculates the max rank

MaxRank = 
CALCULATE(
	MAX(Ranks[Rank]),
	ALL(Ranks))

you then can use it in your gauge

 

Hope this helps!

JJ

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi DoubleJ no not at all actually.  My rank is a measure.  The rank measures themselves look something like:

 

Rank EBIT Per FTE = rankx(
	ALLEXCEPT('Lab List', 'Lab List'[Division]),
	[EBIT Per FTE]
	,
	,
	DESC
)

The reason they are variable is the location selection can influcence what level the ranks are based on and higher order selections can reduce the number of locations considered in the ranking measure.

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous，

    Even though your rankx is a measure, you can still use the formula to create measure as I tested.

    MaxRank = CALCULATE(MAX(Table[Rank EBIT Per FTE]),ALL(Table))

---If there is a filter for the [Rank EBIT Per FTE] measure.

MaxRank = CALCULATE(MAX(Table[Rank EBIT Per FTE]),ALLSELECTED(Table))


    Please feel free to ask if you have other issue.

    Best Regards,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi v-huizhn-msft, thanks for this.  Still didn't work. I'm getting this error:

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi Anonymous,

        Is there any chance to post your sample data or .pbix file for analysis? So that we can post solution which is close to your requirement. Thanks for understanding.

        Best Regards,
        Angelia