Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum Values with an Intermediate Lookup Table

I have two tables, Courses and Lessons.  A course can have muliple lessons.  A lesson can be in many courses.  Because of this, I have a lookup table (~Lookup_Couse-Lessons) with a 1:Many relationshi...
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Anonymous , I assume you use a matrix with Courses[Course] in row field, you may try such a measure to sum up durations of lessons composed in corresponding courses.

    Sum Duration =
CALCULATE ( SUM ( Lessons[Duration in Hours] ), '~Lookup_Couse-Lessons' )
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

Hi, Anonymous , I assume you use a matrix with Courses[Course] in row field, you may try such a measure to sum up durations of lessons composed in corresponding courses.

Sum Duration =
CALCULATE ( SUM ( Lessons[Duration in Hours] ), '~Lookup_Couse-Lessons' )
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Brilliant, thank you!!