topic TOP N With Multiple Condition in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/898966#M8181 <P>Hi Guys,</P><P>Need a little help here.<BR />I want to top 10 of my clients based on their total revenue and a client score that i calculate.<BR />I can just use one filter in the filter pane.How can i achieve this?</P> Tue, 14 Jan 2020 07:16:03 GMT Anonymous 2020-01-14T07:16:03Z TOP N With Multiple Condition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/898966#M8181 <P>Hi Guys,</P><P>Need a little help here.<BR />I want to top 10 of my clients based on their total revenue and a client score that i calculate.<BR />I can just use one filter in the filter pane.How can i achieve this?</P> Tue, 14 Jan 2020 07:16:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/898966#M8181 Anonymous 2020-01-14T07:16:03Z Re: TOP N With Multiple Condition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/899097#M8182 <P>Anonymous</LI-USER>&nbsp;,</P><TABLE><TBODY><TR><TD>Client&nbsp;</TD><TD>Total Revenue</TD><TD>Client Score</TD></TR><TR><TD>Client1</TD><TD>100</TD><TD>70</TD></TR><TR><TD>Client2</TD><TD>90</TD><TD>80</TD></TR><TR><TD>Client3</TD><TD>80</TD><TD>150</TD></TR><TR><TD>Client4</TD><TD>70</TD><TD>90</TD></TR><TR><TD>Client5</TD><TD>60</TD><TD>100</TD></TR></TBODY></TABLE><P>As per the logic you require, which clients should be selected as Top 3 ?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 14 Jan 2020 08:37:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/899097#M8182 knowparthshah 2020-01-14T08:37:09Z Re: TOP N With Multiple Condition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/901635#M8252 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="197265" data-lia-user-login="knowparthshah" class="lia-mention lia-mention-user">knowparthshah</a>Since i have many clients if i rank top 5 according to client score, i will get many clients so to again rank them i need to use the total revenue.</P> Thu, 16 Jan 2020 06:48:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/901635#M8252 Anonymous 2020-01-16T06:48:53Z Re: TOP N With Multiple Condition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/2527210#M70703 <P>You can contatenate the variables you want to see the TopN and use it in the Filter.<BR /><BR /></P><P>In my example I created a new column with Date, Equip and Name. So basically I selected this new field and filtered the Top 5 Loads per day.</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 19 May 2022 16:34:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/TOP-N-With-Multiple-Condition/m-p/2527210#M70703 leandroab1 2022-05-19T16:34:30Z