topic Sum of all values in another table where the column is named a row of the table I am in in DAX Commands and Tips

Sum of all values in another table where the column is named a row of the table I am in

dadson1996 — Sun, 04 Aug 2024 00:23:15 GMT

Hi All,

I am trying to sum all the data in a column of a table where that column name is based on the row name of the table I am in, I am unable to find anything around this and was wondering if anyone had any good examples.

For context the columns are a list of names and I am trying to get a total of their "points" across a list of events.

Thanks in advance!

Re: Sum of all values in another table where the column is named a row of the table I am in

ahadkarimi — Sun, 04 Aug 2024 04:47:38 GMT

This example can help you.

Events table:
Event Alice Bob Charlie
Event1 10 5 8
Event2 7 3 6
Event3 4 8 9
_________________________
Participants table:
Name
Alice
Bob
Charlie
_______________________
Create a measure to sum the points for each participant across all events:

TotalPoints =
VAR ParticipantName = SELECTEDVALUE(Participants[Name])
RETURN
SUMX(
Events,
SWITCH(
ParticipantName,
"Alice", Events[Alice],
"Bob", Events[Bob],
"Charlie", Events[Charlie],
0
)
)