How to create an average field in a table?

[Anonymous]

Hello - 

I am rather new to PowerBI so sorry if this is a simple question. I have a table of raw data that contains an entry each week for 12 different clients, each having 4 metrics we track. I want to know what the average value is for all 12 clients combined each week by metric.

What i want to know if possible is can I create a quick measure to give me these values? See below, the "target" is constant and will not change week to week but the averages will. How do I add these into charts so i can easily toggle between clients and plot them vs the average. 

I currently dont have an option to plot "average" because it doesnt have its own field under the "client" column. 

[vicky_]

Try using a DAX calculation similar to the following:

PDM Average = CALCULATE(AVERAGE([OA Results]), ALLEXCEPT([TableName], [Week]))

You can then use field parameters to allow your users to toggle what measures they want to see on the graph. See this page for more details.

[Anonymous]

Hello!

Thank you for the reply. It does look like this DAX calculation is giving me an accurate value however im still unsure how to plot it.

The one below for example gives me the average by week for the OA Result metric, so i'll need to make a DAX calculation for each of the 4 different metrics. 

However when i try to chart it, it will only let me plot the average. I cant also include the plant that i want to compare it to. The data for each plant is under the "OA Result" field, and i cant plot both the OA result and the PDM Average. Is there anyway to make "PDM average" a part of the "plant" field so it is a selection?