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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

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