PERCENTRANK FUNCTION - Equivalent in DAX

[Imran_Isshack]

Hi Power Bi Friends,

I have inherited an MS Excel model and wanted to transition this to Power Pivot so that It becomes dynamic. 

This Excel model has the PERCENTRANK FUNCTION, which I can't seem to find in DAX. 

Here is my Ms Excel Fromula. How can I mirror this in DAX Language?

PERCENTRANK(IF(Defense_Partners[Position]=$B5,IF(Defense_Partners[Type]="Defendants",Defense_Partners[Rate])),E5)

I) The positions refer to Job tiles

ii) Rate are billing Rates per employee, used to bill clients

iii)Type is a category of employees

Is there a way to simulate this MS Excel formula in DAX?

Imran

[amitchandak]

@Imran_Isshack , refer this

https://community.powerbi.com/t5/Desktop/PERCENTRANK-Inclusive/m-p/81208

or

https://stackoverflow.com/questions/59102487/dax-equivalent-of-excel-percentrank-inc-per-category