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

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

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.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors