Help in Sub Query in DAX Expression

[Anonymous]

I am having difficulty writing a pretty simple DAX expression:

Expression =

CALCULATE(COUNT('Table'[RESPONDENT_ID]), FILTER('Table','Table'[QUESTION_ID] = 6 && 'Table'[answer_short_desc]= "No Change"))     this is simple expression which is working fine.

But i have to pass below expression as inner filter to above expression, but dont know how to do

CALCULATE(COUNT('Table'[RESPONDENT_ID]), FILTER('Table','Table'[QUESTION_ID] = 4 && 'Table'[answer_short_desc]= "Yes"))

I Want to count only those RESPONDENT_ID for QUESTION_ID = 6 , who have Selected "Yes" in QUESTION_ID = 4.

Any help would be very appreciated!! Thanks  🙂 

[amitchandak · Accepted solution]

@Anonymous , Assuming your formulas are correct

countx(filter(summarize('Table', 'Table'[RESPONDENT_ID], "_1", CALCULATE(COUNT('Table'[RESPONDENT_ID]), FILTER('Table','Table'[QUESTION_ID] = 6 && 'Table'[answer_short_desc]= "No Change")) , "_2",CALCULATE(COUNT('Table'[RESPONDENT_ID]), FILTER('Table','Table'[QUESTION_ID] = 4 && 'Table'[answer_short_desc]= "Yes")) ) ,not(isblank([_1])) && not(isblank([_2]))
), [RESPONDENT_ID])

[Anonymous]

@amitchandak  thanks a lot. it is working . 🙂