Get The Highest Count Frequency Of Item Name from data set

[MAAbdullah47]

Hi, I have a data set (Order Id, Customer Id, Item Name, Quantity, Total Sales, Order Type), I want to get the following:

1-The Highest Count(Frequency) For Item Name In All orders. 

2-The Highest Count frequency Of the Order type (Pick-up, Delivery, Di-in).   

Thank You 

[Greg_Deckler · Accepted solution]

In general, you will want to use a SUMMARIZE to summarize the information, grouping by what you want to group by and doing a COUNT. You would then grab the name of the item with the MAX count.

[v-yuezhe-msft · Accepted solution]

@MAAbdullah47,

Please check the example in the blog below. If you need detailed DAX fit for your scenario, please help to share sample data of your table and post expected result in table.

http://www.dutchdatadude.com/power-bi-pro-tip-show-top-x-results-with-rankx-function/

Regards,
Lydia Zhang

[Greg_Deckler · Accepted solution]

In general, you will want to use a SUMMARIZE to summarize the information, grouping by what you want to group by and doing a COUNT. You would then grab the name of the item with the MAX count.

[MAAbdullah47]

Can You narrow you answer by an example? 

[MAAbdullah47]

Ok Can You Show me at least how to get the Highest (TopN) from the field?

No Need to summarize , Please advise.

[MAAbdullah47]

Can you help me by some example text cuz I'm usually do this by (R) ?