Need help Ranking

[abehrmann]

I am attempting to rank some of our employees based on a few sets of metrics. 

Below is a matrix of the aggregated data that i would like to rank them by and a sample of the raw data. 

I cannot seem to rank them based on the aggregated data.. any help would be appreciated !! 

[v-yulgu-msft]

Hi @abehrmann,

Which aggregated data should be based on to calculate rank? Is it a measure? If so, you could try this similar formula:

Rank =
RANKX ( ALL ( Table ), [Measure],, ASC, DENSE )

Regards,

Yuliana Gu

[abehrmann]

I attepted to use that suggestion but the ranking is showing up very odd 

[v-yulgu-msft]

Hi @abehrmann,

What is the formula of [Customer Total total for Assigned to]? Would you please share a sample .pbix file? Do not send me the file with full dataset and senssitive data, just show me the dummy data.

Regards,

Yuliana Gu

[abehrmann]

The formula for Customer Total Customer Total total for Assigned To = CALCULATE( SUM('OfficeTrax_Client'[Customer Total]), ALLSELECTED('OfficeTrax_WO'[Assigned To]) )

[v-yulgu-msft]

Hi @abehrmann,

I was not able to reproduce the same problem on my side. It looks like the formula is right. Maybe you could share the .pbix file with dummy data that can reproduce the same scenario.

Regards,

Yuliana Gu