Query on DAX Code (SUMX)

[abhiram342]

Hi All,

I have two tables as below Events and Registrants 

Events:

EventId EventName
1 A
2 B

Registrants:
EventId RegisterId Views
1            1                2
1            2                4
2            1                5

I would like to add new column to EventTable called TotalViews

Please suggest how can I achive it. I tried using SUMX but not working as expected

EventId EventName TotalViews
1           A                  6
2           B                  5

Thanks,

Abhiram

[CNENFRNL]

Hi, @abhiram342 , you might want to try,

first, create a relationship between Events[EventsId] (1:*) Registrants[EventsId];

then, this DAX formula in calculated column does the trick,

TotalViews = CALCULATE( SUM(Registrants[Views]) )