Forum Discussion

24601's avatar
24601
Frequent Visitor
4 years ago

Measure to Identify Two Matching Values in Same Table

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

3 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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's avatar
      24601
      Frequent Visitor
      4 years ago

      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. 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    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!