Average over multiple rows

DAX DAX Calculations
1

Hey DNA team,

Just need a quick steer on getting the right average total in my last column.

On the following table I want to find the average across the multiple KPI rows.

**Project**           **KPI 1**        **KPI 2**     **KPI 3**         **KPI 4**       **Avg Total**

   1                                 4                     5                   7                        8                               ?

   2                                 5                     6                   8                        6                                ?

cheers Adam

2

Hi @adam,

Thanks for posting your question. Sample pbix will be great to understand your problem and provide a quick fix. Cheers!

3

Thanks for posting your question @adam. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread. Here is a potential list of additional information to include in this thread: demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

4

Hi @adam we’ve noticed that no response has been received from you since the 30th of September. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

5

Not sure if this will help, but this helps give subtotals across rows…