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
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