COUNT in new column

[syafeeq]

I am new with PowerBI 

I would like to count the number of item_code and put it in a new colum. 

so the new column will have

item_code 1 = 3

item_code x = 2

item_code y = 1

etc

How can i do that? 

thanks

[ryan_mayu · Accepted solution]

do you mean by year?

calculate(count(item),allexcept(table, year))

if you want distinct count ,try this

calculate(distinctcount(item),allexcept(table,year)

[ryan_mayu · Accepted solution]

do you mean by year?

calculate(count(item),allexcept(table, year))

if you want distinct count ,try this

calculate(distinctcount(item),allexcept(table,year)

[syafeeq · Accepted solution]

I tried the following & it works for my need

CALCULATE(
COUNT(_TempTable[item_code]),
ALLEXCEPT(_TempTable,_TempTable[item_code])
)

thanks for the tip

[ryan_mayu]

you are welcome