Forum Discussion
Solved
Charting multiple responses questions
Hello Dears, We have a multiple response survey question exported as single column for each answer as 0 if the answer not selected and the answer label if selected. We need to analysis/chart thi...
Veja se ajuda:
- Transformar colunas em linhas no Power Query;
- Fazer a medida abaixo.
Medida = DIVIDE ( COUNTROWS ( Tabela ), COUNTROWS ( ALL ( Tabela[Valor] ) ) )
MySurveyHuB Go into Power Query Editor. Right-click your Id column and choose Unpivot other columns. At this point the calculation should become trivial such as:
Percent Responded Measure =
VAR __Table = 'Table'
VAR __NumberAnswered = FILTER(__Table, [Value] <> 0)
VAR __TotalNumber = COUNTROWS(__Table)
VAR __Result = DIVIDE( __NumberAnswered, __TotalNumber )
RETURN
__ResultGreg_Deckler i got this message in the measure calcuation
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
MySurveyHuB Apologies, missed a COUNTROWS:
Percent Responded Measure = VAR __Table = 'Table' VAR __NumberAnswered = COUNTROWS(FILTER(__Table, [Value] <> 0)) VAR __TotalNumber = COUNTROWS(__Table) VAR __Result = DIVIDE( __NumberAnswered, __TotalNumber ) RETURN __Result