Forum Discussion

abhiram342's avatar
abhiram342
Microsoft 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                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

DAX Calculation

1 Reply

  • CNENFRNL's avatar
    CNENFRNL
    Community 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]) )