Forum Discussion

RalstonT's avatar
RalstonT
Helper I
7 years ago

Average Data

Hello,   Still farily new to Power BI, and really green with DAX.  Normally in Excel I would create a new row that shows the average of the information, but I am not sure how to do it in Power Bi. ...
Need Help
Show and Tell
Cmcmahan's avatar
Cmcmahan
Resident Rockstar
7 years ago

Going back to your original question, since I don't think having the data will help.

For your chart, in the Values section, what value do you use to create the average line?  Is it a measure, or a value in the table?  You can set up a measure for that average line to ignore filters when you go down to the individual level.  Edit the following to fit your fields:

AveragePerformanceMeasure = CALCULATE(AVERAGE(Table1[Performance]), ALLEXCEPT(Table1, Table1[Person]))

This measure is getting the AVERAGE of the field, keeping all current filters except those on Person.  This way, when you select a single person, the average won't change. 

  • RalstonT's avatar
    RalstonT
    Helper I
    7 years ago

    Thank you for your response.  I am trying to enter your suggestion, but I am not that familiar with DAX.  I am trying to find a course I can start to understand it.  What I get is "Too many arguements were passed to the AVERAGE function.  THe maximum argument count for the function is 1."

     

    AveragePerformanceMeasure = CALCULATE(AVERAGE(AgentScorecard[AHT],[Average of Value average per Attribute],ALLEXCEPT(AgentScorecard,AgentScorecard[Associate])))
  • RalstonT's avatar
    RalstonT
    Helper I
    7 years ago

    Hello,

     

    I was able to get this working, but I think I need a solution that works a little differently.  I want to select a manager that has "x" amount of assocaites.  I want it to show that average of the entire team for the TM, and the average for the associate at once.  Not just selected.

    • Cmcmahan's avatar
      Cmcmahan
      Resident Rockstar
      7 years ago

      All of this heavily depends on the context in which you're calculating this average. Is it only when you have a manager selected, or if no manager is selected, should it average all associates?  Once you've selected a manager, should the comparison average never change?

       

      So just to be clear, you have performance data for associates.  Individuals are grouped under a manager.  You want to display each individual's aggregate data in a chart, as well as displaying the same aggregate data for the entire team in the same chart.  

      Is this correct? What kind of visualization are you using?  Do you still want the average of the team as a comparison line, or should the team show up as another "person" in the list alongside the associates it is aggregating?

      • RalstonT's avatar
        RalstonT
        Helper I
        7 years ago

        Hello,

         

        Thanks for the reply.

         

        I am using a line chart, and a bar chart for different points of data.  I would like the manager's team average to be shown when that manager is selected.  I would prefer to have the average of the team shows as another "person" so we can compare side by side.  In the excel example shown above that is what I created with the charts.  I had a line for the average of the team that was always constant.  Then I selected the average, and the associate in a slicer to compare.