Forum Discussion

ysherriff's avatar
ysherriff
Resolver II
3 years ago
Solved

Comparing Top N And Average Of Others

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...
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    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.

v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

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.