Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
EMassicot
Frequent Visitor

DAX to average a measure?

I have a table with the columns "ID" ,"month" , "score" and "publish date". I have a measure that gets me the "average score per publish date" and then I just filter by ID on my report page.

 

What I ultimately want, is to use the values in the measure "averge score per publish date"  to calulcate the average score per month.

 

Here's a table as an example

IDScorePublish DateMonth
1909/14/2022September
1609/14/2022September
1759/15/2022September
1859/15/2022September

 

 

What I want but do not know how to do.

 

Step 1. Averge score per publish date 9/14/2022

90+60 = 150/2= 75

Step 2. Average score per publish date 9/15/2022

85+75= 160/2 = 80

Step 3. Average score per month. ( using average score per publish date to calculate)

80+75= 155/2 = 77.5

 

What I know how to do but do not want.

Step 1. Average score per month( using scores to caluclate)

90+60+85+75 = 77.5

 

Here is also the DAX formula that I used to get the average score per publish date.

 

Average Score Per Publish Date =
CALCULATE(
AVERAGE ( 'Table'[Score] ),GROUPBY('Table','Table'[Publish Date], 'Table '[ID]),
1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

Try:

Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

1 REPLY 1
PaulDBrown
Community Champion
Community Champion

Try:

Average by month = AVERAGEX(VALUES(Table[Month]), [Average Score Per Publish Date])





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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