Comparing Top N And Average Of Others

[ysherriff]

Hi all,

Excellent video about comparing Top N and Average others: by Alex Badiu .

(5) Comparing Top N And Average Of Others In Power BI - YouTube 1

I am trying to copy exactly Alex’s method for my usage and ran into two issues.

1. My Ascending Rank formula counts blank values and therefore is ranking incorrectly… Here is the formula, output and TOPN table below. The issue is my TOPN table has no blank values. All names have values associated with it so I don’t know how to adjust this formula.

1. The second issue is when I try to put in the TopN campaigns and average of Others formula into the table, I get an error message.
   
   

Any help would be massively appreciated. Thanks

[v-xiaotang · Accepted solution]

Hi @ysherriff 

Thanks for reaching out to us.

>> The issue is my TOPN table has no blank values. All names have values associated with it so I don’t know how to adjust this formula.

could you share some sample data and its expected output? 

>>The second issue is when I try to put in the TopN campaigns and average of Others formula into the table, I get an error message.

according to the error message, you compared Number with Text wrongly in the measure,  could you share the .pbix file? so that we can troubleshoot it. 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.