Ranking for PowerPivot

[liybpg]

Hi I am new to PowerPivot, so just trying to get my head around few things. What I am trying to do is to create a ranking Measure which I can put in a pivot table and it would calculate a rank within that category. My dataset looks like that:

Company	Category	Revenue
Target	1	100
Target	2	230
A	1	100
B	2	123
C	1	490
Target	2	839
Target	3	100
C	1	230
D	3	498
D	1	587

<tbody>
</tbody>

So what I want to be able to do is to dynamically rank ‘Target’ company without needing to display all other companies (as I have hundreds). I imagine the pivot looking something like this:

Category	‘Target’ Revenue	‘Target’ Rank
1	X	2
2	Y	3
3	Z	7

<tbody>
</tbody>

Thank you!

 

[scottsen]

The function you are looking for is RANKX. You can certainly do what you want... though, I do find this particular dax function to be trickier than expected, look for samples.

 

[liybpg]

That's what I seem to find as well! Thanks anyway I'll try and decipher how to use it