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...
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] )
)