cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcast
Frequent Visitor

Calculating Average of Sum Measurement

I have created a measurement to calculate the difference between two value from separate table based on date and then take the average of those values, but I can't seem to get the correct average value.  The initial part of the measurement works correctly by getting the difference for each month, but I can't figure out how to get the overall per account_id average once I take out the Date Values in the context??  As you can see in the total line and last snapshot the value is incorrect the total average should be -.46 for the Account_id.

 

jcast_0-1610653082412.png

 
 
 

jcast_4-1610653376708.png

 

 

jcast_10-1610653541986.png

 

 
 
 

 

 

 

 

 

1 ACCEPTED SOLUTION
AlB
Super User III
Super User III

Hi @jcast 

Try this measure based on the one you have

Measure =
AVERAGEX (
    SUMMARIZE ( Table1, Table1[account_id], Table1[Month] ),
    [Current measure]
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

View solution in original post

1 REPLY 1
AlB
Super User III
Super User III

Hi @jcast 

Try this measure based on the one you have

Measure =
AVERAGEX (
    SUMMARIZE ( Table1, Table1[account_id], Table1[Month] ),
    [Current measure]
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors