https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-context-Players-names-with-the-youngest-age-by-country-pbix/m-p/2928978#M96312 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="111755" data-lia-user-login="johnmelbourne" class="lia-mention lia-mention-user">johnmelbourne</a> , Create a new column (rank) like this and filter that for 1</P> <P>&nbsp;</P> <DIV> <DIV>Column = Rankx(FILTER('Data_transfers_22-23', [Country Moving to] = EARLIER([Country Moving to]) ), [Player Age],,ASC,Dense)</DIV> </DIV> Fri, 25 Nov 2022 08:40:47 GMT amitchandak 2022-11-25T08:40:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-context-Players-names-with-the-youngest-age-by-country-pbix/m-p/2928921#M96305 <DIV class=""><DIV class=""><DIV class=""><SPAN>I am trying to calculate the youngest player in each country.</SPAN></DIV></DIV></DIV><DIV class=""><DIV class=""><P>Attached is my pbix:&nbsp;<A href="https://drive.google.com/file/d/1ORDN26jH406gaFc7tiFoHi83Ye7fBwhq/view?usp=sharing" target="_blank" rel="noopener">https://drive.google.com/file/d/1ORDN26jH406gaFc7tiFoHi83Ye7fBwhq/view?usp=sharing</A>&nbsp;</P><P>&nbsp;</P><P>I want a solution like:</P><P>&nbsp;</P><img /><P>&nbsp;</P><P>So something like :&nbsp;</P><P>&nbsp;</P><P><img /></P><P>any assistance would be appreciated. I would appreciate comments in any solution please so I can understand rather than copy and paste.</P><P>&nbsp;</P><P>Kind regards</P><P>John</P></DIV></DIV> Fri, 25 Nov 2022 08:53:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-context-Players-names-with-the-youngest-age-by-country-pbix/m-p/2928921#M96305 johnmelbourne 2022-11-25T08:53:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-context-Players-names-with-the-youngest-age-by-country-pbix/m-p/2928978#M96312 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="111755" data-lia-user-login="johnmelbourne" class="lia-mention lia-mention-user">johnmelbourne</a> , Create a new column (rank) like this and filter that for 1</P> <P>&nbsp;</P> <DIV> <DIV>Column = Rankx(FILTER('Data_transfers_22-23', [Country Moving to] = EARLIER([Country Moving to]) ), [Player Age],,ASC,Dense)</DIV> </DIV> Fri, 25 Nov 2022 08:40:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-context-Players-names-with-the-youngest-age-by-country-pbix/m-p/2928978#M96312 amitchandak 2022-11-25T08:40:47Z