How to find average on matrix?

Tummi · ‎08-22-2022

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.

v-jianboli-msft · ‎09-02-2022

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.

parry2k · ‎08-22-2022

@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!

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎08-22-2022

@Tummi what is the expected output?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Tummi · ‎08-22-2022

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.