Forum Discussion

MySurveyHuB's avatar
MySurveyHuB
Frequent Visitor
3 years ago
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...
Need Help
  • Vilmar's avatar
    Vilmar
    3 years ago

    Veja se ajuda:

    • Transformar colunas em linhas no Power Query;
    • Fazer a medida abaixo.
    Medida = 
DIVIDE ( 
    COUNTROWS ( Tabela ), 
    COUNTROWS ( ALL ( Tabela[Valor] ) )
)

     

Vilmar's avatar
Vilmar
Resolver I
3 years ago

Veja se ajuda:

  • Transformar colunas em linhas no Power Query;
  • Fazer a medida abaixo.
Medida = 
DIVIDE ( 
    COUNTROWS ( Tabela ), 
    COUNTROWS ( ALL ( Tabela[Valor] ) )
)

 

  • MySurveyHuB's avatar
    MySurveyHuB
    Frequent Visitor
    3 years ago

    SUPERRRRRRRRRR

    thanks a lot