Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
Using Summarize, I created a table that has the year, name & point columns.
Solved! Go to Solution.
To achieve this in Power BI using DAX, you can modify your existing SUMMARIZE
function to include a ranking based on the points, and then filter the table to only include the top record per year. Here’s how you can do it:
Table =
VAR SummaryTable = SUMMARIZE(
constructor_results,
races[year],
constructors[name],
"Total Points", SUM(constructor_results[points])
)
VAR RankedTable = ADDCOLUMNS(
SummaryTable,
"Rank", RANKX(FILTER(SummaryTable, [year] = EARLIER([year])), [Total Points], , DESC, Dense)
)
RETURN
FILTER(
RankedTable,
[Rank] = 1
)
Proud to be a Super User!
To achieve this in Power BI using DAX, you can modify your existing SUMMARIZE
function to include a ranking based on the points, and then filter the table to only include the top record per year. Here’s how you can do it:
Table =
VAR SummaryTable = SUMMARIZE(
constructor_results,
races[year],
constructors[name],
"Total Points", SUM(constructor_results[points])
)
VAR RankedTable = ADDCOLUMNS(
SummaryTable,
"Rank", RANKX(FILTER(SummaryTable, [year] = EARLIER([year])), [Total Points], , DESC, Dense)
)
RETURN
FILTER(
RankedTable,
[Rank] = 1
)
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
73 | |
68 | |
63 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |