PercentRank below a fixed value

[mpheelee]

Hello,

I'm looking for a formula that will allow me to identify the % turnaround times for a CT Scan that are below a fixed time such as 120 minutes.  Percentrank.inc(array, 120) works in excel.  

Has anyone found an equivalent in Power BI?

Thanks!

[v-aatheeque]

Hi @mpheelee ,
Thanks for reaching out to Microsoft Fabric Community Forum.
In Power BI, you can use DAX to calculate the percentage of turnaround times below a fixed value like 120 minutes. 
DAX: 
CT Scan % Turnaround Rank = 
VAR CurrentValue = MAX('CT Scans'[Turnaround Time])
RETURN
1 - DIVIDE(
    RANKX(ALL('CT Scans'), 'CT Scans'[Turnaround Time], , ASC),
    COUNTROWS(ALL('CT Scans'))
)

If you still persists the issue @Ashish_Mathur  please share the sample data for more insights.

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.