cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

## 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 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
1 ACCEPTED SOLUTION
Super User

Hi,

Create this calculated column formula

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

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
6 REPLIES 6
Community Support

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.

Super User

Hi,

Create this calculated column formula

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

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
New Member

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?

Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Solution Specialist

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 )

Frequent Visitor

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

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors