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, 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

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