Forum Discussion

WLFRD's avatar
WLFRD
Icon for Helper III rankHelper III
4 years ago

Count per group

Hello,   I think the solution for my question is simple but for some reason I cannot find the answer to my question.   So, I have this table:   Unit B100 B200 B100  C100 C100 ...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
4 years ago

Hi WLFRD 

You can try this,

measure code:

SUM_OF_Unit_measure = 
CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Unit] ) )

calculated column code:

SumOfCount_column = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Unit]))

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.