topic Re: Get the subject in which students scored the max marks using DAX Power BI in DAX Commands and Tips

Get the subject in which students scored the max marks using DAX Power BI

Anonymous — Tue, 10 May 2022 14:06:11 GMT

Consider the Table below

Now i Need to find the subject in which student has scored max marks. Please help with DAX to achieve this
Expected Output

johnt75 — Tue, 10 May 2022 14:57:56 GMT

You can do this with a couple of measures

Top Subject = CONCATENATEX( TOPN( 1, 'Table', 'Table'[Marks]), 'Table'[Subject], ", ") Top Marks = MAX('Table'[Marks])

In case of ties this will return a comma separated list of subjects which shared the same top marks.

Anonymous — Wed, 11 May 2022 06:40:16 GMT

Thanks John what if i just need to get the subject in which student scored the max marks via measure

Anonymous — Wed, 11 May 2022 06:40:30 GMT

Thanks John what if i just need to get the subject in which student scored the max marks via measure

v-xiaotang — Fri, 13 May 2022 06:24:03 GMT

Hi Anonymous

You can try this,

create a measure

maxmarks = CALCULATE( MAX('Table'[Marks]),ALLEXCEPT('Table','Table'[ID]))

then create the table below,

output table = FILTER('Table','Table'[Marks]=[maxmarks])

result

Best Regards,

Community Support Team _Tang

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