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 cou...
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
)
Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution 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
      Icon for Community Support rankCommunity 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
)