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]
)
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi v-huizhn-msft,  Unfortunately the size of the file to too large and full of confidential information.  It wouldn't be a small task to replace the data with a sample set.  I'll just have to live without this function in the meantime.

Anonymous's avatar
Anonymous
Not applicable
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]
)