Forum Discussion

ArashZ's avatar
ArashZ
Helper I
5 years ago

Average based on some specific rows

Hi,   I have a table like this: Each user ID has the course name of base and advanced and the duration is the same for each user based on their course name. In fact, for user A, the duration for th...
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

ArashZ's avatar
ArashZ
Helper I
5 years ago

CNENFRNLThanks. But is there a way to write a calculated column or measure for that?

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago
    Avg = 
SUMMARIZECOLUMNS(
    COURSE[user ID],
    COURSE[Course name],
    "Avg", AVERAGEX( COURSE, COURSE[Start finish duration] )
)

  • PaulOlding's avatar
    PaulOlding
    Solution Sage
    5 years ago

    If you want a measure then it'll need to create the equivalent of the Table.Distinct(Source) table on the fly.

     

    Average Measure =
    AVERAGEX(
    SUMMARIZE('Table', 'Table'[Course name], 'Table'[user ID], 'Table'[Start finish duration]),
    'Table'[Start finish duration]
    )