Forum Discussion
Solved
Column count duplicates
Hello I need to create a column that says how many times the information is repeated in a column. For example, I have a table where each row represents a sale, and in each of these rows there is th...
Hi,
Create this calculated column formula
=calculate(countrows(Data),filter(Data,Data[seller]=earlier([seller])))
Hope this helps.
Hi
Option 1: create an Summarize Table, use CountX funtion, then Look up back
Option 2:
create measure
name_seller = SELECTEDVALUE (Seller column)
create column
count =
var a = measure name_seller
return COUNTX ( FILTER (table, Seller column = a), Seller column )
Multiple solutions posted to similar question, but this is what worked for me.