Forum Discussion

MasterSonic's avatar
MasterSonic
Helper IV
3 years ago
Solved

Count rows per category

Hi Guys

Having this table,

I would like to get count of code per Group. (Code has unique values)

 

CodeGroupResults I would like to get 
101Jeans 2
102Jeans 2
103Suits3
104Suits 3
105Suits 3
106Shoes 1

 

Thanks

  • daXtreme's avatar
    daXtreme
    3 years ago
    [# Codes per Group] = // measure
var VisibleGroups = DISTINCT( T[Group] )
var Result =
    CALCULATE(
        COUNTROWS( T ), // T is your table's name
        VisibleGroups,
        ALLSELECTED( T )
    )
return
    Result

2 Replies

  • daXtreme's avatar
    daXtreme
    Solution Sage
    3 years ago
    [# Codes per Group] = // measure
var VisibleGroups = DISTINCT( T[Group] )
var Result =
    CALCULATE(
        COUNTROWS( T ), // T is your table's name
        VisibleGroups,
        ALLSELECTED( T )
    )
return
    Result