Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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
Why cant you just use TopN? or use RankX to gte list of top 5
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |