DAX Help Required

[SAM_110]

I would like to know how can I get the following results using DAX or anything else in Power BI:

I am using following example to explain the scenario and the desired results:

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.

	2018	2019	2020	2021
Company A	56	76	78	98
Company B	35	46	24	15
Company C	46	67	78	56
Company D	34	36	47	58

[SAM_110]

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

	2018	2019	2020	2021
Company A	56	76	78	98
Company B	35	46	24	15
Company C	46	67	78	56
Company D	34	36	47	58

[KeyurPatel14]

Can you please provide output for better understanding?