Calculating Ranking from already created measure is it possible?

[Mavericks334]

Hi,

I created a measure that is giving the total time a person has spent, i need to create a rank according to this measure.

Is it possible?

Regards,
Renato.

 

[barry houdini]

Have you tried RANK function?

 

[Mavericks334]

Rank would work in a calculated column. however i am using a calculated measure that is pickingup information from multiple columns which i am using in a pivot. i need to create a rank for this final value.

 

[Mavericks334]

Hi Have tried the below function to create a rank,
(RANKX(All('Employee Details'[Employee Name]),'SharePoint Data'[Total Productive Work Per Day]

The problem i am facing is that, the teams that do not perform that particular activity are reflecting in the pivot table and also under the locations that they do not belong to.

Any idea how do i trouble shoot out of this problem.