Query on DAX Code (SUMX)

abhiram342 — Wed, 16 Dec 2020 21:17:52 GMT

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

Re: Query on DAX Code (SUMX)

CNENFRNL — Thu, 17 Dec 2020 00:02:35 GMT

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