Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to create an average field in a table?

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 wan...
Need Help
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

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?