topic Repost from earlier with sample data: PERCENTRANK FUNCTION - Equivalent in DAX in DAX Commands and Tips

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

Imran_Isshack — Thu, 24 Nov 2022 22:24:53 GMT

Hi Power Bi Friends,

I inherited an MS Excel model and wanted to transition it 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?

Rate Graded Position Position Type Firm

=PERCENTRANK(IF(Plaintiff_AllData[Position]="Partner",IF(Plaintiff_AllData[Type]="Category A",Plaintiff_AllData[Rate])),D3)

I) The positions refer to Job tiles

ii) Rates 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

v-yueyunzh-msft — Fri, 25 Nov 2022 01:57:49 GMT

For your need , you want to convert the "PERCENTRANK FUNCTION" to dax . Right?

As searched , 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 :

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Imran_Isshack — Fri, 25 Nov 2022 02:11:06 GMT

Thanks very much for your response.

Yes, I would like the DAX equivalent of Excel's PERCENTRANK.

You're right, I have been searching google for a few days now and can't seem to find the equivalent.

I saw this post before "powerbi - DAX equivalent of Excel PERCENTRANK.INC per category - Stack Overflow" but it seems so long and complicated and scared me away 🙂 . I do hope I would be able to use this successfully.

Imran