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.