cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Highlighting duplicate values in a power BI table

Hi guys,

I am working on a report that shows types and number of outlets that are visited by sales reps. When an sales rep visits an outlet more than once, it appears as a duplicate in our database. I have been asked to highlight which outlets have been visited more than once (duplicated values only) and show the number of revisits done.

I'd appreciate if someone sheds a light on the best approach to solve this.

Thanks.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Highlighting duplicate values in a power BI table

Hi @Kaskazi_Network ,

 

You can group by Outlet and add a record count as a calculated column.

Consequently, you could filter your visual to only show records where this record count > 1.

 

Alternatively, you can use the summarizecolumns function in DAX which actually does the same as the group by but won't store the data in memory. More information on this function you can find here: https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax

 

Was my answer anywhere helpful?

Show your appreciation by simply marking my reply as solution or throw it a kudo. 🙂

 

Hop on the data train and get connected @LouSegers

 

View solution in original post

Highlighted
Community Support
Community Support

Re: Highlighting duplicate values in a power BI table

Hi @Kaskazi_Network 

 

You can use the distinct count to calculate the visits whether more than once, output the value as calculated column. and then use the conditional firmatting to highlight it. 

Please share the dummy pbix with expected results disclosed if you'd like us to draw it up for you.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

4 REPLIES 4
Highlighted
Super User IX
Super User IX

Re: Highlighting duplicate values in a power BI table

@Kaskazi_Network , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted

Re: Highlighting duplicate values in a power BI table

Kaskazi_Network_0-1597400580274.png

The highligted outlets indicate that that outlet was visited three times on different dates. I want to show only these duplicated outlets and indicate the number of all revisits..

Highlighted
Resolver I
Resolver I

Re: Highlighting duplicate values in a power BI table

Hi @Kaskazi_Network ,

 

You can group by Outlet and add a record count as a calculated column.

Consequently, you could filter your visual to only show records where this record count > 1.

 

Alternatively, you can use the summarizecolumns function in DAX which actually does the same as the group by but won't store the data in memory. More information on this function you can find here: https://docs.microsoft.com/en-us/dax/summarizecolumns-function-dax

 

Was my answer anywhere helpful?

Show your appreciation by simply marking my reply as solution or throw it a kudo. 🙂

 

Hop on the data train and get connected @LouSegers

 

View solution in original post

Highlighted
Community Support
Community Support

Re: Highlighting duplicate values in a power BI table

Hi @Kaskazi_Network 

 

You can use the distinct count to calculate the visits whether more than once, output the value as calculated column. and then use the conditional firmatting to highlight it. 

Please share the dummy pbix with expected results disclosed if you'd like us to draw it up for you.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors