Forum Discussion
veranceftw
Helper II
Helper IIGroup By two columns and associate with a third column
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...
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 🙂
Fowmy
Super User
Super Userveranceftw
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 🙂
veranceftwHelper II
Helper IIIt worked, thanks! Can you just give me a quick explanation?