Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Total is incorrect. Need help to fix the issue.
Updated the data and table only show 1 row for station S1. Table still unable to show top 2 for each station.
Program | STATION | TYPE |
A | S1 | F6 |
A | S1 | F6 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F3 |
A | S2 | F3 |
A | S2 | F3 |
A | S1 | F2 |
A | S1 | F3 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F1 |
B | S2 | F3 |
B | S1 | F3 |
B | S2 | F3 |
B | S2 | F3 |
B | S1 | F3 |
B | S1 | F3 |
B | S2 | F3 |
B | S2 | F3 |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F3 |
A | S2 | F3 |
A | S2 | F3 |
A | S1 | F2 |
A | S1 | F3 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F1 |
B | S2 | F3 |
B | S1 | F4 |
B | S2 | F4 |
B | S2 | F5 |
B | S1 | F4 |
B | S1 | F4 |
B | S2 | F5 |
B | S2 | F3 |
Thanks..but still having issue when the data is updated, only Top 1 is shown for station S1.
Program STATION TYPE
A S1 F6
A S1 F6
A S2 F2
A S2 F2
A S1 F3
A S2 F3
A S2 F3
A S1 F2
A S1 F3
A S2 F2
A S2 F2
A S1 F1
A S1 F1
A S2 F1
B S2 F3
B S1 F3
B S2 F3
B S2 F3
B S1 F3
B S1 F3
B S2 F3
B S2 F3
A S1 F1
A S1 F1
A S2 F2
A S2 F2
A S1 F3
A S2 F3
A S2 F3
A S1 F2
A S1 F3
A S2 F2
A S2 F2
A S1 F1
A S1 F1
A S2 F1
B S2 F3
B S1 F4
B S2 F4
B S2 F5
B S1 F4
B S1 F4
B S2 F5
B S2 F3
Hello @CTH2022 can you share the table data instead of the image that would be really helpfull.
Program | STATION | TYPE |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F3 |
A | S2 | F3 |
A | S2 | F3 |
A | S1 | F2 |
A | S1 | F3 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F2 |
B | S2 | F3 |
B | S1 | F3 |
B | S2 | F3 |
B | S2 | F3 |
B | S1 | F3 |
B | S1 | F3 |
B | S2 | F3 |
B | S2 | F3 |
@CTH2022 , Try like
top 2 =
var rankingcontext = values(Sheet1[TYPE])
return
Sumx(Summarize(Sheet1, Sheet1[STATION], Sheet1[Program], "_1",
calculate([counting],
topn(2,all(Sheet1[TYPE]),
[counting]),rankingcontext)),[_1])
The solution seems to work. However, when I added more data, the table started to display more than top 2 per station. Need help to fix this.
Program | STATION | TYPE |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F3 |
A | S2 | F3 |
A | S2 | F3 |
A | S1 | F2 |
A | S1 | F3 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F1 |
B | S2 | F3 |
B | S1 | F3 |
B | S2 | F3 |
B | S2 | F3 |
B | S1 | F3 |
B | S1 | F3 |
B | S2 | F3 |
B | S2 | F3 |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F3 |
A | S2 | F3 |
A | S2 | F3 |
A | S1 | F2 |
A | S1 | F3 |
A | S2 | F2 |
A | S2 | F2 |
A | S1 | F1 |
A | S1 | F1 |
A | S2 | F1 |
B | S2 | F3 |
B | S1 | F4 |
B | S2 | F4 |
B | S2 | F5 |
B | S1 | F4 |
B | S1 | F4 |
B | S2 | F5 |
B | S2 | F3 |
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |