• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need DAX formula to find Item wise count with in category


New Member

in my query , each item in each category considered as a group. I sorted the data based on below conditions.

** "item" in the category should show based on highest sales to lowest sales.
** If "item" sales are same in the category, then we need to consider "item" alphabetical order. The "item" should comes first which "item" alphabet is big.

Now , I need to write DAX formula (in "New column") to find item wise(group) count with in category.

Note: sample output shown in the "G" column. (See attachment)

Any help would be appreciated.

Raj Kumar