Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
SUMMARIZE(
ADDCOLUMNS(
ADDCOLUMNS(
'table aaaaaaa',
"Rank", RANKX(ALL('table aaaaaaa'[sessionid]), 'table aaaaaaa'[sessionid], , ASC)
),
"IsFirst", [Rank] = 1
),
'table aaaaaaa'[sessionid],
"Total Sessions",
CALCULATE(
SUM('table aaaaaaa'[sessions]),
[IsFi
rst]
)
)
Solved! Go to Solution.
Hi @Tryingpod ,
Please try the following methods and check if they can solve your problem:
1.Create the simple table.
2.Create the new table to Rank.
Table Rank_id = SUMMARIZE(
'Table',
'Table'[sessionid],
"Total Sessions",
CALCULATE(
SUM('Table'[session])
),
"Rank", RANKX(ALL('Table'[sessionid]), 'Table'[sessionid], , ASC)
)
3.Drag the table into the table visual. The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Tryingpod ,
Please try the following methods and check if they can solve your problem:
1.Create the simple table.
2.Create the new table to Rank.
Table Rank_id = SUMMARIZE(
'Table',
'Table'[sessionid],
"Total Sessions",
CALCULATE(
SUM('Table'[session])
),
"Rank", RANKX(ALL('Table'[sessionid]), 'Table'[sessionid], , ASC)
)
3.Drag the table into the table visual. The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SUMMARIZE(
ADDCOLUMNS(
ADDCOLUMNS(
'table aaaaaaa',
"Rank", calculate(RANKX(ALL('table aaaaaaa'[sessionid]), 'table aaaaaaa'[sessionid], , ASC))
),
"IsFirst", [Rank] = 1
),
'table aaaaaaa'[sessionid],
"Total Sessions",
CALCULATE(
SUM('table aaaaaaa'[sessions]),
[IsFirst]
)
)
let me know if this works for you .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
User | Count |
---|---|
105 | |
98 | |
97 | |
68 | |
34 |
User | Count |
---|---|
146 | |
141 | |
116 | |
98 | |
52 |