Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

Filter based on another field in teh same table

Hello,    I ahve a table T! with teh following fields   ID -- Location -- Cust -- Status-- CUST_ACCT 1 -- CA -- John -- Active --12 2 -- TX -- Jerry -- InActive -- 2 3 -- NY -- Jedd -- Active ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi sabeensp ,

    For your requirement, you could create the calculated column with the dax below.

    Table =
FILTER (
    'Table_T',
    'Table_T'[CUST_ACCT] <> 'Table_T'[ID]
        && SEARCH ( "C", 'Table_T'[Location], 1, 0 )
)

    Here is the output.

    Best Regards,

    Cherry