Divide 2 columns and count per category beforehand

[MasterSonic]

Hello,

I have a Table where Code is unique.

I would like to get a division of stock by count of Group values please 

Eg.

Stock = 40, count of Jeans=2 so 40/2=20

Code	Group	stock	Result I would like to get
101	Jeans	40	20
102	Jeans	40	20
103	Suits	60	20
104	Suits	60	20
105	Suits	60	20
106	Shoes	10	10

Thank You

[FreemanZ]

you may also try

Column=

VAR CurrentGroup = TableName[Group] 

VAR CurrentStockType = TableName[Stock] 

VAR CurrentGroup =

COUNTROWS(

     FILTER(

        TableName,

        TableName[Group] = CurrentStockType

     )

)

RETURN

DIVIDE ( CurrentGroup, CurrentGroup )

[MasterSonic]

Hi there,

I did try your solution and have an issues.

Shouldn't be second

VAR CurrentGroup

Different name like CurrentGroup2 ?

I have error about that.

I did change it , but still showing that can not transform values from Group of type text into number 

[tamerj1 · Accepted solution]

Hi @MasterSonic 

please try

CalculatedColumn =
DIVIDE (
'Table'[Stock],
COUNTROWS ( CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Group] ) ) )
)