Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@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]?
our report has changed direction so I no longer need this, thank you for your help though @tamerj1
Hi @blue_0720
please try
Average Measure =
AVERAGEX ( SUMMARIZE ( 'Date', 'Date'[Year], 'Date'[Quarter] ), [Measure] )
User | Count |
---|---|
25 | |
11 | |
8 | |
7 | |
6 |
User | Count |
---|---|
24 | |
13 | |
12 | |
10 | |
6 |