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])))