Forum Discussion
Helper VGet The Highest Count Frequency Of Item Name from data set
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
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,
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
5 Replies
- Greg_Deckler
Community Champion
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.
MAAbdullah47Can you help me by some example text cuz I'm usually do this by (R) ?- 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 narrow you answer by an example?
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