Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Yuhanna Sherriff]

Hi all,

Excellent video about comparing Top N and Average others.

(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) . The first issue is 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.

ii.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 is appreciated. Thank you.

——————————
Yuhanna Sherriff
——————————