undefined

[Anonymous]

Hi,

I want to count how many duplicate values are in the column. But want this in a calculated column rather that measure.

thanks,

[vanessafvg]

@Anonymous can you give an example of what you asking?  ie.

col 1   calculated column

1         3

1         3

1         3

2         2

2         2

?

[Anonymous]

@vanessafvg Yes this is what I am looking

[vanessafvg]

@Anonymous i can only figure out how to use it in a calculated measure

ie. 

calculate(countx(table, table[column])

will a measure not work for you?  the other way of doing it is to summarize the table and then create a relationship to it

ie.

summarize (table, table[column], "count" countx(table, table[column]))

[Anonymous]

@vanessafvg Thank you for your time. I have already tried calculated function with measure which is working fine for me. But there is requirement for a colunm which we need to add with desired output. I beleive we don't have any workaround for it.

[vanessafvg]

must be a way to do it

also this

ie. 

calculate(countx(table, table[column])

will a measure not work for you?  the other way of doing it is to summarize the table and then create a relationship to it

ie.

summarize (table, table[column], "count" countx(table, table[column]))