RANKX function but excluding low volume records

[steven_j]

Hi all,

Below is an example of a table I have in Power BI.  I'm using the Rank function to show the top 5 emails by click rate.  The problem is I want to exclude the email with only 2 delivered emails.  Everynow and then I'll see an email with only a few records come through.  I want to add a condition to the rank function where it only ranks emails with x number of emails delivered.  Any ideas?

[steven_j · Accepted solution]

I found the solution:

Click Rate Rank = IF([Total Emails Delivered] > 999,

    RANKX(FILTER(

    ALLSELECTED('Live Contact & Cross Sell'[Email Template]),[Total Emails Delivered]>999),[Click Rate],,DESC,Dense))