Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mahsy
Helper I
Helper I

Show duplicate rows

Hi !!

 

I want to display in the graphic the number of duplicate rows according to date. But i don't know how to count uniquely multiple columns.

 

mahsy_0-1652169485819.png

 

Thank you for your help !

 

 

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @mahsy ,

 

Please try this measure. And set the filters as shown in the figure.

Measure = COUNTROWS('Table') - COUNTROWS(SUMMARIZE('Table','Table'[Course],'Table'[PR],'Table'[Date]))

vcgaomsft_0-1652429572288.png

Attached PBIX file for reference.

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

View solution in original post

5 REPLIES 5
v-cgao-msft
Community Support
Community Support

Hi @mahsy ,

 

Please try this measure. And set the filters as shown in the figure.

Measure = COUNTROWS('Table') - COUNTROWS(SUMMARIZE('Table','Table'[Course],'Table'[PR],'Table'[Date]))

vcgaomsft_0-1652429572288.png

Attached PBIX file for reference.

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

Arul
Super User
Super User

@mahsy ,

create a calculated column like the below and put that column in the X-axis (values) or Y-axis (values), then set the aggregation as count.

 

Earlier = COUNTX(filter(Table_count,EARLIER(Table_count[Course])=Table_count[Course] && EARLIER(Table_count[PR])=Table_count[PR] &&EARLIER(Table_count[Date])=Table_count[Date]),Table_count[Course])

 

Arul_0-1652182762208.png

Arul_2-1652183082383.png

Thanks,

Arul

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Thank you.

Unfortunately i'm in live  connection, so i can't create calculated column.

@mahsy ,

try this in measure,

cal = CALCULATE(COUNT(Table_count[Course]),FILTER(ALL(Table_count),
COUNTX(filter(Table_count,
EARLIER(Table_count[Course])=Table_count[Course] && 
EARLIER(Table_count[PR])=Table_count[PR] &&
EARLIER(Table_count[Date])=Table_count[Date]),
Table_count[Course])))

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Here is what i get. It counts all rows. 

 

mahsy_0-1652187425676.png

 

I just want to count duplicate rows. Here is the expected result.

 

mahsy_1-1652187649476.png

thank you for your help !

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors