Forum Discussion

veranceftw's avatar
veranceftw
Icon for Helper II rankHelper II
6 years ago
Solved

Group 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...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    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

Anand24's avatar
Anand24
Icon for Super User rankSuper User
6 years ago

veranceftw ,

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

  • veranceftw's avatar
    veranceftw
    Icon for Helper II rankHelper II
    6 years ago

    The last column should be the output 🙂 Anand24 

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      6 years ago

      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's avatar
        veranceftw
        Icon for Helper II rankHelper II
        6 years ago

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