Forum Discussion
MasterSonic
Helper IV
Helper IVCount rows per category
Hi Guys Having this table, I would like to get count of code per Group. (Code has unique values) Code Group Results I would like to get 101 Jeans 2 102 Jeans 2 103 Suits ...
[# 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
daXtreme
Solution Sage
Solution Sage[# 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
MasterSonicThank You