Measure to Identify Two Matching Values in Same Table

[24601]

Hi, I've searched for something to help with me this but haven't quite found the answer so hopefully I can get some guidance here. 

Below is a very simple mockup of my situation. 

There is one instance where the Item ID has the same Reason For Return on both occasions, #1. 

Item ID Reason For Return
1 Faulty
2 Bought in Error
3 Bought in Error
4 Bought in Error
5 Replacement
6 Bought in Error
7 Bought in Error
8 Bought in Error
9 Faulty
1 Faulty
2 Replacement
3 Faulty

I am looking for a measure that will give me a count the number of instances like this which will also be used as a filter. 

I am currently using a calculated column to concatente and then a measure to count the instances where there is more than one occurance of that concatenation. So, "1Faulty" would return 2 whereas everything else would return a 1.

Any help would be appreciated.

Thanks

[tamerj1]

@24601 
Yes this is possible. But I need more details:

1. Provide detailed discription of your original report that contains the measures to be compared. What are you slicing by in this report (the column on the rows of the matrix). What is the code of your measures.
2. The structure of your data: Tables, relationships and invloved columns.
3. Detailed explanation of the 2nd report that need to be filtered and the expected results.

Thank you and have a great day!

[tamerj1]

Hi @24601 

can you please clarify further what do you exactly mean by "I am looking for a measure that will give me a count the number of instances like this which will also be used as a filter." Do you mean to use the measure as slicer for example? Can you please provide sample of the expected results and the detais of your report visual. 

[24601]

Hi @tamerj1 

Sorry if I was not clear with my query.

I am looking to identify when two data in two columns match but in a measure rather than a calculated column and to use it for two purposes.
1) To use in a card to give a view of the total of instances 
2) To be used in a table as a filter to identify orders that have duplicate Reasons for Return.

Unfortunately, I cannot provide a visual of what I would like this to look like that moment. 

I hope I've explained myself better this time.