undefined

Question

Hi,&nbsp;I want to count how many duplicate values are in the column. But want this in a calculated column rather that measure.&nbsp;thanks,

vanessafvg · Answer

must be a way to do it&nbsp;also this&nbsp;ie.&nbsp;&nbsp;calculate(countx(table, table[column])&nbsp;will a measure not work for you? &nbsp;the other way of doing it is to summarize the table and then create a relationship to itie.&nbsp;summarize (table, table[column], "count" countx(table, table[column]))

vanessafvg · Answer

Anonymous&nbsp;can you give an example of what you asking? &nbsp;ie.&nbsp;col 1 &nbsp; calculated column1 &nbsp; &nbsp; &nbsp; &nbsp; 31 &nbsp; &nbsp; &nbsp; &nbsp; 31 &nbsp; &nbsp; &nbsp; &nbsp; 32 &nbsp; &nbsp; &nbsp; &nbsp; 22 &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp;&nbsp;?&nbsp;

anonymous · Answer

vanessafvg&nbsp;Yes this is what I am looking

vanessafvg · Answer

Anonymous&nbsp;i can only figure out how to use it in a calculated measure&nbsp;ie.&nbsp;&nbsp;calculate(countx(table, table[column])&nbsp;will a measure not work for you? &nbsp;the other way of doing it is to summarize the table and then create a relationship to itie.&nbsp;summarize (table, table[column], "count" countx(table, table[column]))

anonymous · Answer

vanessafvg&nbsp;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&nbsp;we need to add with desired output. I beleive we don't have any workaround for it.

Forum Discussion

undefined

5 Replies

Related content

undefined

undefined

undefined

undefined

undefined