RANKX function but excluding low volume records

Question

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

steven_j · Accepted Answer

I found the solution:Click Rate Rank = IF([Total Emails Delivered] &gt; 999,&nbsp; &nbsp; RANKX(FILTER(&nbsp; &nbsp; ALLSELECTED('Live Contact &amp; Cross Sell'[Email Template]),[Total Emails Delivered]&gt;999),[Click Rate],,DESC,Dense))

Forum Discussion

RANKX function but excluding low volume records

1 Reply

Related content

Drill through excluding specific record

Exclude blanks when using the GENERATESERIES function

Sorting Records

DISTINCTCOUNT excluding certain records

Counting Non-Blank Records