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]
)
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: