Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
It worked, thanks! Can you just give me a quick explanation?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |