Help with finding duplicate incidents

Hi Anonymous ,

Try this  as a calculated column:

Incident Count > 1 =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[CostomerID] = EARLIER ( 'Table'[CostomerID] )
            && 'Table'[Date] = EARLIER ( 'Table'[Date] )
            && 'Table'[Incident] = EARLIER ( 'Table'[Incident] )
    )
) > 1
 

sample result:

Please note that one row for customer ID4448 on 3/Jan does not match your criteria of being a duplicate.

Hi Anonymous!

As far I've understood, your main criteria is to see all the information that also has an issue with it. If so, I'm thinking about a switch, where you could select "Has an issue", and filter only the ones that have it. I would do it this way:

1) Create a new table on power query, containing these info: 

2) After you create a measure for the value of the switch:

3) You create a measure for the information to be shown:
_If issue = if(

4) You create a measure for the switch itself:

5) You put in a slicer the first column "Has an Issue" of the first table that you've created (in step 1), in order to filter your data, and show only the rows that have an issue:

I think it should work 😄 

*If it works, please remember to mark me as a solution (and to give a kudo wouldn't be bad also hahaha) 😉