Forum Discussion

Kiven_03's avatar
Kiven_03
Regular Visitor
2 years ago
Solved

Window Function for Student marks

Hi, I have issue in finding a solution, please help me with it.   I have a table "X_Marks", where columns are (ResultYear (ex: 2021-2022), School_ID, Roll_Number, Subject_Code, Marks). The Resul...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Here is a radically different approach

    Add all marks together and then subtract the smallest mark.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Kiven_03 

 

Thanks for the reply from lbendlin .

 

Maybe you can try the following:

Top5 = 
SUMX(
    TOPN(
        5, 
        'Table',
        'Table'[Marks]
    ), 
    'Table'[Marks]
)

 

Output:

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Kiven_03's avatar
    Kiven_03
    Regular Visitor
    2 years ago

    Thank you very much Anonymous .

    I have already tried this and It didn't work.
    If 50,50,66,72,93,73 are the subjects marks then total marks of 6 subject is 404, and total marks of top 5 is also 404(because all 6 subjects comes under top 5 as 2 subject values are equal). If any marks are equal I am not able get the top 5 total marks.

    I really appericiate for your time 😃, 
    Thank you very much.
    Mean while if I get the solution I will post it.