Forum Discussion
Top Performing Customer
I have been looking around and could not find something to recreate. I am trying to find the Top Performing Customer (corporation) based on Total Sales Measure. I have pasted a sample data of the table I am working with (of course there is more data)
Anyways I am trying to show the top performing account managers followed by the distinct count of corps they are working with, followed by the total sales, then the top performing CORP(customer) by sales.
I have completed everything but the top performing customer. I was wondering if anyone has performed this already.
| Date | Year | Month Num | Month Nam | YYYYMM | AIRLINE | POS | CORP | INDUSTRY | POS FULL | Contract type | Dest | ACCT MANAGER | Contract? | Class | Sales | Type | Meassure Sales | Meassure Type |
| 7/7/2016 0:00 | 2016 | 7 | Jul | 201607 | DL | MX | Jet engines inc | Computer Software | MEXICO | (EPL-01) | Mexico | John Does | Y | Economy | 0 | 0 | 0 | 0 |
| 4/4/2016 0:00 | 2016 | 4 | Apr | 201604 | UA | MX | The chemical company | Chemicals | MEXICO | (EPL-01) | Mexico | Mike Smith | Y | Economy | 500 | 1 | 0 | 0 |
| 8/8/2016 0:00 | 2016 | 8 | Aug | 201608 | AA | MX | The chemical company | Chemicals | MEXICO | (EPL-01) | Mexico | Mike Smith | Y | Economy | 600 | 1 | 0 | 0 |
Yes, you can do that.
Take a look at these videos. I think this should help.
https://www.youtube.com/watch?v=hX-s1htBdmk&list=PL1myWUzvmmDHhhTxEzEYSDZzDx7JVKTQ7&index=17
https://www.youtube.com/watch?v=bbM7JSQqn2I&t=1s&list=PL1myWUzvmmDHhhTxEzEYSDZzDx7JVKTQ7&index=54
https://www.youtube.com/watch?v=ljAINOUt-X8&list=PL1myWUzvmmDHhhTxEzEYSDZzDx7JVKTQ7&index=39
3 Replies
Becuase I am trying to create more of a summary for each salesperson. Showing Total Accounts, Total Sales, and Top performing customer. Just the name of the largest account. Is that possible with topN. I would not say I am new to DAX, but I am always learning and trying to push my self to create better metrics and reports. You guys help out a lot :)
Yes, you can do that.
Take a look at these videos. I think this should help.
https://www.youtube.com/watch?v=hX-s1htBdmk&list=PL1myWUzvmmDHhhTxEzEYSDZzDx7JVKTQ7&index=17
https://www.youtube.com/watch?v=bbM7JSQqn2I&t=1s&list=PL1myWUzvmmDHhhTxEzEYSDZzDx7JVKTQ7&index=54
https://www.youtube.com/watch?v=ljAINOUt-X8&list=PL1myWUzvmmDHhhTxEzEYSDZzDx7JVKTQ7&index=39
