Forum Discussion
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 exported this into a sheets and got it into the Power query.
Now, I want PBI to delete (or ignore) this "others..." options and count each checkbox (separeted in comas inside the column) to make the graphics. Can someone help me? I am recent to PBI.
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
9 Replies
The red arrows are pointing to an "Others..." option and the coma division I said before. It's in portuguese. lc_finance
Hi gabrielrca ,
Do you have a separate column listing all the predefined answers?
That separate column can be used for the count
If yes, let me know and i'll propose a solution
Luca
