Forum Discussion
PercentRank below a fixed value
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. ...
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!