+ Reply to Thread
Results 1 to 7 of 7

AVERAGEX using measure and formula

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    AVERAGEX using measure and formula

    Hi,
    I've noticed I sometimes get a discrepancy between using average with a measure or formula

    so; AVEGARGX ( Table, [Total sales Measure] ) measure = SUMX( Table1, Table1[Sales] * RELATED( Table2[Price] ))

    and AVERAGEX( Table1 Table1[Sales] *RELATED( Table2[Price] )

    RD
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: AVERAGEX using measure and formula

    Where's the discrepancy??
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Re: AVERAGEX using measure and formula

    11.6 for one and 12.4 for the other, i have put them both in the attachment.

    rd

  4. #4
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Re: AVERAGEX using measure and formula

    The reason is because of duplicate records, context transition causes them to be 'grouped' and counted so the two "a 2" are put together and counted and then again, can be solved by having unique identifier such as Index column.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: AVERAGEX using measure and formula

    Well spotted! And you have the satisfaction of having sorted it yourself....

  6. #6
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Re: AVERAGEX using measure and formula

    By myself with the help of Mike Girvin, MSPTDA 18 ;

    Please Login or Register  to view this content.
    Richard.

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: AVERAGEX using measure and formula

    Never disclose your sources!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Averagex measure in datamodel
    By hansolu in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-13-2021, 01:12 AM
  2. [SOLVED] How to measure time of formula calculations ?
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2019, 04:27 AM
  3. Pivot Table: Grand Total different measure from Column measure
    By chinneywow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2019, 06:22 AM
  4. Dax Formula to Average a Max Measure
    By travis.cook21 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-20-2017, 04:19 PM
  5. [SOLVED] Help with Formula to measure performance
    By rv02 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 01-28-2016, 02:43 AM
  6. Formula to measure Fatigue
    By tvt0290 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2013, 06:37 AM
  7. PowerPivot Measure Formula
    By Twi78 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2012, 08:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1