Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Query on DAX Code (SUMX)

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          ...
DAX Calculation
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
5 years ago

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