topic Re: count how many times the value is repeated in DAX Commands and Tips

count how many times the value is repeated

Anonymous — Mon, 04 Dec 2023 19:24:30 GMT

Hello!

I need a help to create a new collunm at power BI using DAX. In my example I have a colunm1 with some values that are repeat. I need a collunm that count how many times the value is repeated:

Colunm1	How many times
A	3
A	3
A	3
B	2
B	2
C	4
C	4
C	4
C	4
D	1

Anybody can help me? Thanks a lot.

Re: count how many times the value is repeated

ray_codex — Mon, 04 Dec 2023 19:38:55 GMT

U need context transition:

CALCULATE(COUNT(Table[Column1]))

This creates a filter on the value in the first column, counting the unique filtered values.

Re: count how many times the value is repeated

Fowmy — Mon, 04 Dec 2023 19:40:15 GMT

Anonymous

New Col = CALCULATE( COUNTROWS( TableName), ALLEXCEPT( TableName , TableName[Column1] ) )

Re: count how many times the value is repeated

Anonymous — Mon, 04 Dec 2023 19:46:39 GMT

Fowmy

Thanks !