# Top 5 Residual Risk list

**URL:** <https://community.eazybi.com/t/top-5-residual-risk-list/14456>\
**Category:** Questions & Answers\
**Tags:** jira\
**Created:** [December 6, 2023, 2:57am UTC](https://community.eazybi.com/t/top-5-residual-risk-list/14456 "2023-12-06T02:57:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Horne](https://community.eazybi.com/user_avatar/community.eazybi.com/david_horne/32/11453_2.png) [@David\_Horne](https://community.eazybi.com/u/David_Horne)\
**Post date:** [December 6, 2023, 2:57am UTC](https://community.eazybi.com/t/top-5-residual-risk-list/14456/1 "2023-12-06T02:57:57Z")

</div>

Hey team,

I am trying to build a report that Ranks Residual or Inherent risk against their related issue.

I understand doing a top 5 but, that only seems to list the first 5 Residual risks, I am keen on it doing a Top based on their significance i.e. Extreme, High, Medium, Low.

So, if we have 25, and I select to show the Top with the most significance.

I have tried the following , but am not getting the result I am chasing:

Rank(  
[Issue].CurrentHeirarchyMember,  
Order(  
Filter(  
[Residual Risk Level].[Residual Risk Level].Members,  
[Measures].[Open Issues] \> 0),  
[Measures].Residual Risk Level], BASC)  
)

This result just gives me a zero.

Any tips on where I am going wrong?

Thanks in advance

Dave

---

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [December 8, 2023, 7:50am UTC](https://community.eazybi.com/t/top-5-residual-risk-list/14456/2 "2023-12-08T07:50:38Z")

</div>

Hi,

The rank function finds the rank of the member (first argument) in the set (second argument). You have provided Issue dimension member as the first argument and looking for its rank in the Residual Risk Level member set. The rank will always be zero as the issue cannot be a member in the risk level set.

Please explain more details on how your top risk report shall be constructed should you need further guidance.

Kindly,  
Janis, eazyBI support

---

<div class="post-metadata">

**Author:** ![David\_Horne](https://community.eazybi.com/user_avatar/community.eazybi.com/david_horne/32/11453_2.png) [@David\_Horne](https://community.eazybi.com/u/David_Horne)\
**Post date:** [December 10, 2023, 7:56pm UTC](https://community.eazybi.com/t/top-5-residual-risk-list/14456/3 "2023-12-10T19:56:11Z")

</div>

Hi @janis.plume ,

Thanks for the response.

What I am trying to achieve is to provide a report that automatically lists the top 5 or top 10 issues with Residual Risks ranked by their significance, i.e. Extreme, Medium, Low or trivial.

At the moment the Top 5 is just showing the first five residual risks that are listed, regardless of severity.

I hope this is clearer.

Regards

Dave

---

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [December 12, 2023, 5:36pm UTC](https://community.eazybi.com/t/top-5-residual-risk-list/14456/4 "2023-12-12T17:36:45Z")

</div>

Hi,

Thank you for the update.

Please check if the following approach could work for your case.

1. Create a custom calculation that translates the Residual Risk values to numeric values.

The formula could look like this (assuming you use the Issue dimension in the report rows):

```auto
CASE [Issue].CurrentHierarchyMember.GetString('Residual Risk Level')
WHEN "Extreme" THEN 10
WHEN "Medium" THEN 8
WHEN "Low" THEN 5
WHEN "Trivial" THEN 3
END 

```

With this measure you can apply the Top N fitler in the report:

 ![image](https://community.eazybi.com/uploads/default/original/2X/9/9298f5b35b968006cdb809b228a3bcbda65d356a.png)

This filter will dynamically show top N issues with the highest Risk level.

Kindly,  
Janis, eazyBI support

---

<div class="post-metadata">

**Author:** ![David\_Horne](https://community.eazybi.com/user_avatar/community.eazybi.com/david_horne/32/11453_2.png) [@David\_Horne](https://community.eazybi.com/u/David_Horne)\
**Post date:** [December 12, 2023, 7:54pm UTC](https://community.eazybi.com/t/top-5-residual-risk-list/14456/5 "2023-12-12T19:54:39Z")

</div>

@janis.plume thank you for this, it is exactly what I needed.

Really appreciate your assistance with this.

Regards

Dave