cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## How do I write a measure that averages column totals?

Beginner user here and have never asked a question in a forum before so I apologize in advance for the simplicity of the question or info I might miss adding for context.

I have this table that I'm trying to replicate from Excel. I have included a screenshot of the Excel version and the Power Bi version. I want to display the average of the sums of each quarter. I am displaying this single value in a card (the one that is showing 131.85% right now) (I couldn't figure out how to do it in the table matrix). I know it can be done with DAX as a measure but can't seem to figure out what that would be. Is there an easy way to do this? I want the average to be off the quarters that have data, excluding the zeros for the future quarters).

Excel version:

Power BI version:

Thank you in advance for the help.

4 REPLIES 4
New Member

@tamerj1  I have the data for this table with a field for Quarter and that is linked to a Calendar table so am I referencing the Quarter field in this table or do I reference the fields in my Calendar table? Also, what goes where you have [Measure]?

Super User

which of them is usef in the visual?

New Member

our report has changed direction so I no longer need this, thank you for your help though @tamerj1

Super User

Average Measure =
AVERAGEX ( SUMMARIZE ( 'Date', 'Date'[Year], 'Date'[Quarter] ), [Measure] )

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors