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.

     

kpost's avatar
kpost
Icon for Solution Sage rankSolution Sage
3 years ago

Does this work?  (The paren

AVERAGE_BY_REVENUE% =
CALCULATE(

       AVERAGEX(
              VALUES(Table[Revenue Growth']),
              COALESCE(SUM(Table['Nr of companies']), 0)
                        ), 
ALL(Table[CLO Name])
)

//Mediocre Power BI Advice, but it's free//
MartynasBI's avatar
MartynasBI
Frequent Visitor
3 years ago

Hi kpost 

 

Unfortunately it did not work

 

  • kpost's avatar
    kpost
    Icon for Solution Sage rankSolution Sage
    3 years ago

    It would be a measure, not a column.

    • MartynasBI's avatar
      MartynasBI
      Frequent Visitor
      3 years ago

      Unfortunately a measure in this case is not sufficient, as it cannot be added to the visual

  • 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,