Forum Discussion

MartynasBI's avatar
MartynasBI
Frequent Visitor
3 years ago
Solved

adding an average measure to a chart with existing column variables

Hi,   I have the following area chart visual, which contains a legend of two variables (CLO A and CLO B).   I would like to calculate the average value of the CLO A and CLO B, and add that ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, MartynasBI 

     

    You can try the following methods.

    Column:

    Average = AVERAGEX(FILTER('Table',[Revenue growth]=EARLIER('Table'[Revenue growth])),[Nr of companies])

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

     

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, MartynasBI 

 

You can try the following methods.

Column:

Average = AVERAGEX(FILTER('Table',[Revenue growth]=EARLIER('Table'[Revenue growth])),[Nr of companies])

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

 

MartynasBI's avatar
MartynasBI
Frequent Visitor
3 years ago

Hi v-zhangti ,

 

Yes, the numbers are correct, thanks!

 

However, I Power BI does not allow me to add this newly created column to the area chart visual Y axis. Do you know any workarounds around that?

 

Thanks,