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] ) ) )
Greg_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