count no.of same values in a given column

[Anonymous]

Hi All,

I need a solution to calculate simple logic using Dax. My table consists of only one columns, which contains some values in it. I need to create another column which represents the count of same value in the first column.

Example:

Values         Count

A                     3

A                     3

A                     3

B                     2

B                     2

C                     1

In the above example, A is presented 3 times in the values column, so i need to put count 3 in all the rows which contains A. Like that B is presented 2 times in the values column, therefore i need to put count 2 in all the rows which contains B ans so on.

Thanks in advance.

[amitchandak · Accepted solution]

@Anonymous ,

calculate(count(Table[Values]), allexcept(Table,Table[Values]))

[littlemojopuppy]

Try this...

Playing:=
	COUNTROWS(
		FILTER(
			Table2,
			Table2[Values] = SELECTEDVALUE(Table2[Values])
		)
	)