Repost from earlier with sample data: PERCENTRANK FUNCTION - Equivalent in DAX

Question

Hi Power Bi Friends,I inherited an MS Excel model and wanted to transition it to Power Pivot so that It becomes dynamic.&nbsp;This Excel model has the PERCENTRANK FUNCTION, which I can't seem to find in DAX.&nbsp;Here is my Ms Excel Fromula. How can I mirror this in DAX Language?&nbsp;PositionCompaniesCountMIN VALUEPERCENTRANKMAX VALUEPERCENTRANKAVERAGEPERCENTRANKPartners&nbsp;&nbsp;$%$%$%&nbsp;Ace Store5$18,45019%$28,12530%$23,28823%&nbsp;Acme Corporation&nbsp;12$14,62513%$54,00094%$34,31336%&nbsp;Cupcake LLC2$13,0509%$15,07514%$14,06312%&nbsp;Éclair Inc6$31,50031%$43,87567%$37,68842%&nbsp;Grant &amp; Eisenhoffer P.A.2$20,25022%$33,75034%$27,00028%&nbsp;Globex Corporation4$10,1250%$12,3755%$11,2501%&nbsp;Home Furnishing8$39,37552%$58,50098%$48,93886%&nbsp;Hooli8$32,62533%$46,12581%$39,37552%&nbsp;&nbsp;&nbsp;Rate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Graded Position&nbsp; &nbsp; Position&nbsp; &nbsp; &nbsp; &nbsp;Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Firm $24,750Senior AssociatePartnerCategory AAce Store$18,450Senior AssociatePartnerCategory AAce Store$26,100Senior AssociatePartnerCategory AAce Store$21,375Senior AssociateAssociateCategory AAce Store$28,125Senior AssociatePartnerCategory AAce Store$24,975Financial AnalystFinancial AnalystCategory AAce Store$26,775InvestigatorPartnerCategory AAce Store$26,775InvestigatorInvestigatorCategory BAce Store$18,000InvestigatorInvestigatorCategory BAce Store&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=PERCENTRANK(IF(Plaintiff_AllData[Position]="Partner",IF(Plaintiff_AllData[Type]="Category A",Plaintiff_AllData[Rate])),D3)&nbsp;I) The positions refer to Job tilesii) Rates are billing Rates per employee, used to bill clientsiii)Type is a category of employees&nbsp;Is there a way to simulate this MS Excel formula in DAX?Imran

v-yueyunzh-msft · Accepted Answer

Hi ,&nbsp;&nbsp;Imran_Isshack&nbsp;
For your need , you want to convert the "PERCENTRANK FUNCTION" to dax . Right?
As searched ,&nbsp;there is no PERCENTRANK function in DAX, you can manually calculate it from the results of RANKX and COUNTROWS.
For more information, you can refer to :
powerbi - DAX equivalent of Excel PERCENTRANK.INC per category - Stack Overflow
&nbsp;
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!&nbsp;
&nbsp;
Best Regards,
Aniya Zhang
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly
&nbsp;
&nbsp;

Forum Discussion

Repost from earlier with sample data: PERCENTRANK FUNCTION - Equivalent in DAX

2 Replies

Related content

PERCENTRANK (Inclusive)

DAX equivalent to the Excel Proper function

DAX SQL window function equivalent

Equivalent of Tableau Function: Window_sum()

equivalent function of Networkdays in DAX

Position	Companies	Count	MIN VALUE	PERCENTRANK	MAX VALUE	PERCENTRANK	AVERAGE	PERCENTRANK
Partners			$	%	$	%	$	%
	Ace Store	5	$18,450	19%	$28,125	30%	$23,288	23%
	Acme Corporation	12	$14,625	13%	$54,000	94%	$34,313	36%
	Cupcake LLC	2	$13,050	9%	$15,075	14%	$14,063	12%
	Éclair Inc	6	$31,500	31%	$43,875	67%	$37,688	42%
	Grant & Eisenhoffer P.A.	2	$20,250	22%	$33,750	34%	$27,000	28%
	Globex Corporation	4	$10,125	0%	$12,375	5%	$11,250	1%
	Home Furnishing	8	$39,375	52%	$58,500	98%	$48,938	86%
	Hooli	8	$32,625	33%	$46,125	81%	$39,375	52%