Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Measure to compare text strings

I have two tables joined on Doc_no   Table 1 Doc_no Description Serial_Number  (text string)   Table 2 Doc_no Description PN_Serial_Number  (text string) I want to find out when Table 1 Se...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Anonymous,

     

    A measure can't be used in Visual/Page/Report level filters pane, only columns can be placed.

     

    In your scenario, assume the relationship between the Table1 and Table2 is 1:n, you can create a calculated column in Table2 like below below:

     

    Condition = IF('Table2'[PN_Serial_Number]=RELATED(Table1[Serial_Number]),"Y","N")

     

    Then drag this column to the Visual Level Filters pane, select "N" value.

     

    Best Regards,
    Qiuyun Yu

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Anonymous,

 

A measure can't be used in Visual/Page/Report level filters pane, only columns can be placed.

 

In your scenario, assume the relationship between the Table1 and Table2 is 1:n, you can create a calculated column in Table2 like below below:

 

Condition = IF('Table2'[PN_Serial_Number]=RELATED(Table1[Serial_Number]),"Y","N")

 

Then drag this column to the Visual Level Filters pane, select "N" value.

 

Best Regards,
Qiuyun Yu