Creating a new Table based on conditions

[acg]

I need to create a new table in power BI to write down the follwing (sql)condition:

WITH CTE_1 AS (
--Yes/No Logic applied
SELECT *
FROM [IDW_mart_DEV].[dbo].[v_q]
WHERE
([Question Code] = 'CFOFRQ0036' 
OR [Question Code] ='CFOFRQ0037')
AND [Answer Boolean Value] IN ('Yes' , 'No')
)

What I have done so far is:

Yes/No Logic =

CALCULATETABLE('Fact QNA','Dim Questions'[Question Code]= "CFOFRQ0036" , 'Dim Questions'[Question Code]= "CFOFRQ0037" ,'Fact QNA'[Answer Boolean Value]= "Yes" && "No")

How do I implement the ( OR)  AND 

condition. 

I tried it, but dod not work. 

Any ideas are much appreaciated. 

[acg]

wonderful, thank you for the learning opportunity!

[MahyarTF · Accepted solution]

Hi,

Use in {} in your Code :

Yes/No Logic =

CALCULATETABLE('Fact QNA','Dim Questions'[Question Code] in {"CFOFRQ0036" , "CFOFRQ0037"} ,'Fact QNA'[Answer Boolean Value] in {"Yes", "No"})

Thanks for Kudos,

and please select it as a solution if helps