Google forms data edit.

Hi gabrielrca ,

Regarding crossing with other survey questions, yes it's possible! To do that we need to change from a calculated column to a calculated measure.

Here is a screenshot

And here is the formula for the calculated measure instead of calculated column (it's almost the same, with the addition of SELECTEDVALUE)

contar como conheceu = 
VAR currentAnswer = SELECTEDVALUE(Planilha1[Como conheceu])

RETURN 

 SUMX(
     'Respostas ao formulário 1',
    VAR respondentAnswer = 'Respostas ao formulário 1'[Por quais meios você conheceu a Academia Compasso?]
    RETURN
    IF(ISERROR(SEARCH(currentAnswer,respondentAnswer)),0,1)
 )

And you can download the Power BI example from here.

Best of luck for analyzing your survey. If you need any more help, do not hesitate contacting me.

Regards,

LC

Want to learn Power BI and DAX? Check out my blog at www.finance-bi.com