topic Re: DAX Help Required in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Required/m-p/3110034#M109811 <P>Thank you for looking into this. I have already given the desired table structure. I am pasting it again. The following table should show the results of Top 5 Companies for each Agent. Agents will be selected via Slicer in a dropdown list</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>&nbsp;</P></TD><TD><P>2018</P></TD><TD><P>2019</P></TD><TD><P>2020</P></TD><TD><P>2021</P></TD></TR><TR><TD><P>Company A</P></TD><TD><P>56</P></TD><TD><P>76</P></TD><TD><P>78</P></TD><TD><P>98</P></TD></TR><TR><TD><P>Company B</P></TD><TD><P>35</P></TD><TD><P>46</P></TD><TD><P>24</P></TD><TD><P>15</P></TD></TR><TR><TD><P>Company C</P></TD><TD><P>46</P></TD><TD><P>67</P></TD><TD><P>78</P></TD><TD><P>56</P></TD></TR><TR><TD><P>Company D</P></TD><TD><P>34</P></TD><TD><P>36</P></TD><TD><P>47</P></TD><TD><P>58</P></TD></TR></TBODY></TABLE> Fri, 03 Mar 2023 10:44:35 GMT SAM_110 2023-03-03T10:44:35Z DAX Help Required https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Required/m-p/3109986#M109806 <P>I would like to know how can I get the following results using DAX or anything else in Power BI:</P><P>&nbsp;</P><P>I am using following example to explain the scenario and the desired results:</P><P>&nbsp;</P><P>I have a table called Registrations. It contains all the Registeration of Products since last 10 years. The Registrations are done by Agents and they register products purchased by Companies or Individuals. I am only interested in Companies. So what I need is to get the Top 5 Companies (Count of the products sold) for each Agent (I will use slicer to filter Agents) in a table by Year. Something like the following table when I select Agent007 from the slicer.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>&nbsp;</P></TD><TD><P>2018</P></TD><TD><P>2019</P></TD><TD><P>2020</P></TD><TD><P>2021</P></TD></TR><TR><TD><P>Company A</P></TD><TD><P>56</P></TD><TD><P>76</P></TD><TD><P>78</P></TD><TD><P>98</P></TD></TR><TR><TD><P>Company B</P></TD><TD><P>35</P></TD><TD><P>46</P></TD><TD><P>24</P></TD><TD><P>15</P></TD></TR><TR><TD><P>Company C</P></TD><TD><P>46</P></TD><TD><P>67</P></TD><TD><P>78</P></TD><TD><P>56</P></TD></TR><TR><TD><P>Company D</P></TD><TD><P>34</P></TD><TD><P>36</P></TD><TD><P>47</P></TD><TD><P>58</P></TD></TR></TBODY></TABLE> Fri, 03 Mar 2023 10:09:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Required/m-p/3109986#M109806 SAM_110 2023-03-03T10:09:57Z Re: DAX Help Required https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Required/m-p/3110013#M109809 <P>Can you please provide output for better understanding?</P><P>&nbsp;</P> Fri, 03 Mar 2023 10:32:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Required/m-p/3110013#M109809 KeyurPatel14 2023-03-03T10:32:24Z Re: DAX Help Required https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Required/m-p/3110034#M109811 <P>Thank you for looking into this. I have already given the desired table structure. I am pasting it again. The following table should show the results of Top 5 Companies for each Agent. Agents will be selected via Slicer in a dropdown list</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>&nbsp;</P></TD><TD><P>2018</P></TD><TD><P>2019</P></TD><TD><P>2020</P></TD><TD><P>2021</P></TD></TR><TR><TD><P>Company A</P></TD><TD><P>56</P></TD><TD><P>76</P></TD><TD><P>78</P></TD><TD><P>98</P></TD></TR><TR><TD><P>Company B</P></TD><TD><P>35</P></TD><TD><P>46</P></TD><TD><P>24</P></TD><TD><P>15</P></TD></TR><TR><TD><P>Company C</P></TD><TD><P>46</P></TD><TD><P>67</P></TD><TD><P>78</P></TD><TD><P>56</P></TD></TR><TR><TD><P>Company D</P></TD><TD><P>34</P></TD><TD><P>36</P></TD><TD><P>47</P></TD><TD><P>58</P></TD></TR></TBODY></TABLE> Fri, 03 Mar 2023 10:44:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-Help-Required/m-p/3110034#M109811 SAM_110 2023-03-03T10:44:35Z