Forum Discussion

gabrielrca's avatar
gabrielrca
Regular Visitor
6 years ago
Solved

Google forms data edit.

I made a google forms with lots of multiple choice questions and some checkboxes. The problem is these checkboxes have the "Others..." option, wich means that people can write things in it. I've expo...
Need Help
  • lc_finance's avatar
    lc_finance
    6 years ago

    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

gabrielrca's avatar
gabrielrca
Regular Visitor
6 years ago

I want to be able to cross all this data. It means that I want to be able to cross, for example, this "Sim" or "Não" lines with ppl that checked "Emagrecimento" at google forms. Another problem that you will see in my BI sample is that the graphics are, for some reason, inverted. It seems that it is counting how many times it IS NOT apearing. lc_finance 

 

https://gofile.io/?c=bq7zwb  Link to my BI sample

 

lc_finance's avatar
lc_finance
Icon for Solution Sage rankSolution Sage
6 years ago

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