Forum Discussion

webbj's avatar
webbj
Icon for Helper I rankHelper I
4 years ago
Solved

Novice; API RAW data manipulation to calculate CSAT

Hello All, I'm a complete novice with PowerBI and data analysis in general.. so any help would be much appreciated.    I am trying to calculate average CSAT inside Powerbi. The RAW data is being pu...
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    @ , create a measure like


    Count of results.categories x Count of weight.score =
    sumx('CSAT Categories[Avaiable category Name]', calculate( COUNTA('CSAT Results'[results.categories]) * MAx('CSAT Response Weight'[weight.score])))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

@ , create a measure like


Count of results.categories x Count of weight.score =
sumx('CSAT Categories[Avaiable category Name]', calculate( COUNTA('CSAT Results'[results.categories]) * MAx('CSAT Response Weight'[weight.score])))

webbj's avatar
webbj
Icon for Helper I rankHelper I
4 years ago

Sorry for the delay! - this really helped thankyou