topic Re: count no.of same values in a given column in DAX Commands and Tips

count no.of same values in a given column

Anonymous — Thu, 31 Dec 2020 14:26:44 GMT

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

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.

Re: count no.of same values in a given column

littlemojopuppy — Thu, 31 Dec 2020 14:39:57 GMT

Try this...

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

Re: count no.of same values in a given column

amitchandak — Thu, 31 Dec 2020 14:42:05 GMT

Anonymous ,

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