Reply
Highlighted
Regular Visitor
Posts: 31
Registered: ‎05-03-2017
Accepted Solution

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.

 

DateYearMonth NumMonth NamYYYYMMAIRLINE POSCORPINDUSTRYPOS FULLContract typeDestACCT MANAGERContract?ClassSalesTypeMeassure SalesMeassure Type
7/7/2016 0:0020167Jul201607DLMXJet engines incComputer SoftwareMEXICO(EPL-01)MexicoJohn DoesYEconomy0000
4/4/2016 0:0020164Apr201604UAMXThe chemical companyChemicalsMEXICO(EPL-01)MexicoMike SmithYEconomy500100
8/8/2016 0:0020168Aug201608AAMXThe chemical companyChemicalsMEXICO(EPL-01)MexicoMike SmithYEconomy600100

Accepted Solutions

All Replies
Regular Visitor
Posts: 34
Registered: ‎09-10-2017

Re: Top Performing Customer

Why cant you just use TopN? or use RankX to gte list of top 5 

Regular Visitor
Posts: 31
Registered: ‎05-03-2017

Re: Top Performing Customer

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 Smiley Happy

Regular Visitor
Posts: 34
Registered: ‎09-10-2017