Forum Discussion
DAX Help Required
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 |
2 Replies
Can you please provide output for better understanding?
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
