Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 will therefore show on the guage where you rank sits.  Being 10th out of 1000 means a lot more than being 10th of 11.

So if i place the Rank measure into a matrix, i can see values from 1 to 84.  If i change the filter, now its 1 to 192.  What i'm looking for is a method to return that max value (84 or 192 respectively).  Anyone know of a trick to do this?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

7 REPLIES 7
DoubleJ
Solution Supplier
Solution Supplier

Hi @Anonymous

 

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

Rank_01.PNG

 

This measure calculates the max rank

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

you then can use it in your gauge

Rank_02.PNG

 

Hope this helps!

JJ

Anonymous
Not applicable

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.

 

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
Not applicable

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

 

Capture.PNG

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
Not applicable

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
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.