Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Match and no match

Hi Community,

 

I would like to be able to show customers a list of engineers where the Engineer specified the product that they care about, but did not specify the company brand.  I believe we could do this by creating a new measure, or possibly a new column. 

 

Example: 

If project 123456 is a match for the product search (ID # 3) AND is NOT a match for the brand search (ID # 8) then I want to show the Engineer for that project.  If both IDs are a match, I do not want to show the architect for that project.

 

So, a visual way of explaining this is, if:

 

Project                 ID 3                        ID 8          Show Engineer?

123456               Match                  Match                                 No

123456               Match                  No Match                           Yes

123456               No Match            Match                                 No

123456               No Match            No Match                           No

 

Please Help.

 

Thanks,

Paruchuri

Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may refer to the measure below.

    Measure =
IF (
    CONTAINS ( Table1, Table1[Id], 3 ) && NOT ( CONTAINS ( Table1, Table1[Id], 8 ) ),
    1
)

3 Replies

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi Anonymous,

     

    Please try this formula in a column and check image below:

    Test = if(AND(Data[Product]="Match",Data[Brand]="No Match"),"No","Yes")

     Let us know if it does not work...

     

    Ninter.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

       Hi Interkoubess

       

      Thanks for your reply. This  is not what i am looking for.

       

      I have explained the same in the example. If the project number is found in both id(3 and 8)  then i don't want to show the record. If the project number is found in only one of the search then i want show the record. 

       

      Project No       Id
      123456             3
      123456             8

      If the data is like above i don't want to show.

      Project No       Id
      123456             3

      If the data is like above i want to show.


      Thanks,

      Paruchuri

       

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        8 years ago

        Anonymous,

         

        You may refer to the measure below.

        Measure =
IF (
    CONTAINS ( Table1, Table1[Id], 3 ) && NOT ( CONTAINS ( Table1, Table1[Id], 8 ) ),
    1
)