Can I use the TopN Function in DAX to order data by another column

[Conzo12]

Hi all, I am brand new to this forum so I apologise in advance if I do not give all the information that is required. I will however try and explain this as best as I can. I have a table as follows:

I have a table with thousands of rows. The two key columns of interest are included in the sample table I have provided below.

Order Number	Country
36478849	Ireland
36478849	Ireland
22761993	USA
48475793	Germany
48475793	Germany
48475793	Germany
12436657	USA

I am trying to create a visual that gives me the Top country by number of sales order numbers. I also have some other filters that I have to apply but this isn't relevant to my query so I have not included the fields above. My desired result is for it to say:

Germany

3

I did find away to achieve this using the filter menu as it allows you to do a Top N on the "Country" field but actually use the "Order Numbers" as the value it looks at. Please see below (Legal Entity is Country in my example). 

The reason why this isn't good enough for me is because I need to be able to further manipulate this data into a pertage of other figures. This is why my thoughts were to create a meausre and to use the TopN function as part of a Calculate. Please see my DAX formula below:

GreatestLEnotinCETotal = CALCULATE(COUNT(TABLE1[SALESORDERNUMBER]),TABLE1[IsValueInCE]="No",TOPN(1,TABLE1,FO_OrderLines[LEGALENTITYNAME],0))

I initially had thought this had worked as it give me the exact total I needed (i.e Germany     3) but then I noticed that instead (unlike in the filter menu above) it takes the Top one alphabetically or ascending or decending and doesn't allow for sorting on another column (in my case sales order number by country with the most occurances). Please let me know if you have any information that can help me or require any more info from my side.

Thank you in advance.

Conzo 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Conzo12]

Thank you so much Ashish. That worked great.

[Ashish_Mathur]

You are welcome.

[StefanoGrimaldi]

it depend on what you enter to the dax topn parameters, its giving you the alphabetically order cause you use in the parameter the legaenititname instead of a value, if oyu want the topn by value, need to enter the column reference to the value result not the name