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.  Below are pictures of what I have in BI and an excel example that I use.  I am able to select the average of a Team in excel and compare it with 1 select individual.  In Power BI it shows the average line of all the associated, but when I select the associated it  will show just that person and the average of them.

Need Help
Show and Tell

12 Replies

  • sokg's avatar
    sokg
    Solution Supplier
    7 years ago

    Can you provide us with sample data???

      • sokg's avatar
        sokg
        Solution Supplier
        7 years ago

        In a table form please , so we can use it with power bi.

        We want to copy paste.

        All your data is in one table???

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