Forum Discussion
Count Distinct by Grouping
Hi, This is a very simple thing but I cant seem to get to the bottom of it. I need to create a measure that gives me the count distinct by a grouping. For example TableA Group Attributes...
Anonymous , Try a measure
calculate(distinctcount(Table[Attributes]), filter(allselected(Table), Table[Group] = max(Table[Group] ) ) )
smpa01 Is there a reason for the iterators rather than writing this?
CALCULATE ( DISTINCTCOUNT ( t2[Attributes] ), ALLEXCEPT ( t2, t2[Group] ) )
AlexisOlson great..skipped my mind.