Column count duplicates

[RafaelCM]

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 the name of the salesperson; I need to create a column in this table that says how many times the seller's name is repeated, without using groupings.

Seller	Date	Value	Count
Rafael	11/08/2022	100	3
José	11/08/2022	200	1
Zé	11/08/2022	300	1
João	11/08/2022	400	1
Zezinho	11/08/2022	500	1
Rafael	11/08/2022	600	3
Rafael	11/08/2022	700	3

[theov]

Hey there,

In old days it was done by EARLIER function but now you can use varibales to do it.

You can watch this video too.

https://www.youtube.com/watch?v=JI-QUASKuUw

[v-jianboli-msft]

Hi @RafaelCM ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur · Accepted solution]

Hi,

Create this calculated column formula

=calculate(countrows(Data),filter(Data,Data[seller]=earlier([seller])))

Hope this helps.

[RafaelCM]

thank you so much
however I have one more problem, in the dashboard I have a data filter, how do I make this formula obey the data filter? should I create a measure instead of a column? Does this formula also work if you are going to use it in a measure?

[Ashish_Mathur]

This formula's result will not update based on a slicer selection - only measures do.  Why should the count change based on a date slicer selection.  Share some data and show the expected result.  

[HoangHugo]

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 )

[ePros]

Multiple solutions posted to similar question, but this is what worked for me.