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.
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:
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:
Solved! Go to Solution.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!