topic Re: How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752353#M146369 <P>I'm not following.&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Sat, 09 Mar 2024 04:07:28 GMT lbendlin 2024-03-09T04:07:28Z How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3751969#M146336 <TABLE border="1"><TBODY><TR><TD>Employee Name</TD><TD>ratings</TD></TR><TR><TD>A</TD><TD>5</TD></TR><TR><TD>B</TD><TD>5</TD></TR><TR><TD>C</TD><TD>5</TD></TR><TR><TD>D</TD><TD>5</TD></TR><TR><TD>E</TD><TD>5</TD></TR><TR><TD>F</TD><TD>5</TD></TR><TR><TD>G</TD><TD>5</TD></TR><TR><TD>H</TD><TD>4</TD></TR><TR><TD>I</TD><TD>4</TD></TR><TR><TD>J</TD><TD>5</TD></TR><TR><TD>K</TD><TD>5</TD></TR><TR><TD>L</TD><TD>4</TD></TR><TR><TD>M</TD><TD>5</TD></TR></TBODY></TABLE><P>The Output should be</P><TABLE border="1"><TBODY><TR><TD>Employee Name</TD><TD>ratings</TD></TR><TR><TD>A</TD><TD>5</TD></TR><TR><TD>B</TD><TD>5</TD></TR><TR><TD>C</TD><TD>5</TD></TR><TR><TD>D</TD><TD>5</TD></TR><TR><TD>E</TD><TD>5</TD></TR><TR><TD>F</TD><TD>5</TD></TR><TR><TD>G</TD><TD>5</TD></TR><TR><TD>J</TD><TD>5</TD></TR><TR><TD>K</TD><TD>5</TD></TR><TR><TD>M</TD><TD>5</TD></TR></TBODY></TABLE> Fri, 08 Mar 2024 18:20:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3751969#M146336 Anonymous 2024-03-08T18:20:56Z Re: How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752200#M146350 <P>TOPN(10, Table, NameRatings, DESC)</P> <P>&nbsp;</P> <P>Note this will not be deterministic even if you specify how to handle ties.</P> Fri, 08 Mar 2024 23:12:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752200#M146350 lbendlin 2024-03-08T23:12:04Z Re: How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752350#M146368 <P>We can't pass a column without using aggregation function in Topn function because it's takes only a single scalar value</P> Sat, 09 Mar 2024 04:01:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752350#M146368 Anonymous 2024-03-09T04:01:38Z Re: How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752353#M146369 <P>I'm not following.&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Sat, 09 Mar 2024 04:07:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752353#M146369 lbendlin 2024-03-09T04:07:28Z Re: How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752364#M146370 <P><img /></P><P>i am getting this error&nbsp;</P> Sat, 09 Mar 2024 04:24:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752364#M146370 Anonymous 2024-03-09T04:24:59Z Re: How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752690#M146395 <P>Has to be a calculated table, not a measure.</P> Sat, 09 Mar 2024 13:56:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752690#M146395 lbendlin 2024-03-09T13:56:39Z Re: How can I get the top 10 performers (only 10 rows) from a table only by using DAX for duplicate rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752765#M146397 <P>hi&nbsp;Anonymous</LI-USER>&nbsp;</P><P>&nbsp;</P><P>Assumption : Employee will not be repeated, need to pass unique ID.</P><P>&nbsp;</P><DIV><DIV><SPAN>Rank Emp =</SPAN></DIV><DIV><SPAN>RANK</SPAN><SPAN>(</SPAN><SPAN>DENSE</SPAN><SPAN>, </SPAN><SPAN>ALL</SPAN><SPAN>(</SPAN><SPAN>Table3</SPAN><SPAN>), </SPAN><SPAN>ORDERBY</SPAN><SPAN>(</SPAN><SPAN>Table3</SPAN><SPAN>[Nameratings]</SPAN><SPAN>, </SPAN><SPAN>DESC</SPAN><SPAN>, </SPAN><SPAN>Table3</SPAN><SPAN>[Employee]</SPAN><SPAN>, </SPAN><SPAN>ASC</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Sat, 09 Mar 2024 16:05:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-can-I-get-the-top-10-performers-only-10-rows-from-a-table/m-p/3752765#M146397 talespin 2024-03-09T16:05:09Z