Forum Discussion
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. ...
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.