• 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

    Hui...

  • 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

b_raj_kumar

New Member
Hi

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.

Regards
Raj Kumar
 

Attachments

  • group sales.xlsx
    10 KB · Views: 4
Not sre, try in any cell in row 2:
Code:
=MATCH($A2 &"¬" & $B2,UNIQUE(FILTER($A$2:$A$18 &"¬" & $B$2:$B$18,$A$2:$A$18=A2)),0)
 
Back
Top