Filter based on another field in teh same table

[sabeensp]

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 -- 3

4 -- CA -- Zac -- Active -- 18

I need to create a grid in Power BI, based on follwing SQL Query, that I have, basically converting my SQL Statrement to DAX

Select ID, Location, Cust , Status

FROM T1

Where Location like 'C%'

and

CUST_ID <> CUST_ACCT

Thanks in advance.

[v-piga-msft]

Hi @sabeensp ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your desired output so that we could help further on it.

Best Regards,

Cherry

[v-piga-msft · Accepted solution]

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

[gpiero]

@sabeensp 

Hi

please check if the pbix attached is what you are looking for.

regards

https://1drv.ms/u/s!Ah7_1Sua__g-2yshvqaWgwdsKKTv?e=whNiU3