Table showing incorrect total

[CTH2022]

Total is incorrect. Need help to fix the issue.

[BIswajit_Das]

Hello @CTH2022 try this out

[CTH2022]

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

[CTH2022]

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

[BIswajit_Das]

Hello @CTH2022 can you share the table data instead of the image that would be really helpfull.

[CTH2022]

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

counting = countax(Sheet1,[TYPE])

top 2 =

var rankingcontext = values(Sheet1[TYPE])

return

calculate([counting],

topn(2,all(Sheet1[TYPE]),

[counting]),rankingcontext)

Wanted to table to show top 2 'TYPE' for each station.

[amitchandak]

@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])

[CTH2022]

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