Group By two columns and associate with a third column

[veranceftw]

Hello, I have a sample dataset where:

- One actor belongs to only one Series

- This series repeats itself throughout some episodes with the same Actors

- This actors can score some points 

- I forgot to put in the image, but I also have a third column - season. Series and Episodes should also be grouped by a season

I want to know, the points that the whole series actors do per episode, a feature where each actor has the series score per episode. 

DEFINE 
VAR __me = all_series_stats[actor]
VAR __ptab =
    SUMMARIZE (
        all_series_stats,
        all_series_stats[series],
        all_series_stats[episode],
        all_series_stats[season],
        "Cnt", SUM ( all_series_stats[points] )
    )

I tried to do this, but I am having some problems associating the result with the correspondent actor

Any idea on how to do this?

Regards

[Anand24]

@veranceftw ,

Can you give an example of how your output should look like?

[veranceftw]

The last column should be the output 🙂 @Anand24 

[Fowmy · Accepted solution]

@veranceftw 

Add this as a new column in all_series_stats  table.

Measure = 

CALCULATE(
    SUM ( all_series_stats[points] ),
    ALLEXCEPT(
        all_series_stats,
        all_series_stats[series],
        all_series_stats[episode],
        all_series_stats[season]
    )
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[veranceftw]

It worked, thanks! Can you just give me a quick explanation?