I am working on this criteria where I have 6 columns called candidate id, qualification, country, gender, subject, grade. Now I want one candidate each of grade in (a,b,c,d,e,f) from country as India and one candidate each of grade in (a,b,c,d,e,f) from country as any other country except India. Additionally another criteria in this is one candidate each of subject in (maths, english, hindi) & grade in (1,2,3). I am trying to solve it through DAX.
I tried doing in SQL using row indexing but I am not able to do in Dax.