Forum Discussion

Tummi's avatar
Tummi
Frequent Visitor
4 years ago

How to find average on matrix?

I've built out a matrix from a PBI dataset given to me, and I'm currently trying to build out an average column. 

 

Each column provides a month with x amount of count values in each row. Is there a way for me to build out an average formula to find the average of all the columns and rows?

 

Note: When I used the new measure feature and did =AVERAGE(EXTENDED_PRICE). The output of that formula spit out EXTENDED_PRICE/Lines for each row.

 

If further explanation is required please let me know.

Need Help

4 Replies

    • Tummi's avatar
      Tummi
      Frequent Visitor
      4 years ago

      Output for the first Row:

      [January EXTENDED_PRICE (1,368,593) + February EXTENDED_PRICE (1,616,822) + March EXTENDED_PRICE (1,823,531) + April EXTENDED_PRICE (1,530,250)] / 4 Months = 1,584,799.

       

      Hoping to be able to do that for each row here.

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    4 years ago

    Tummi assuming the month is from the calendar dimension, add the following measure:

     

    Avg = AVERAGEX ( VALUES ( Calendar[Month] ), [Extended Price] )

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Tummi ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    Refer to:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

     

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.