Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago
Solved

NPS Score Calculation

I have a measure with NPS calculation as per below picture.  Right now I have it dividing it by total number of rows (or total number of entries/surveys).  I need to change it to based on IF the pers...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Try for total

    calculate(countrows('30 days Survey'),not(isblank('30 days survey'[Rating])))

     

    Change table and column name.

amitchandak's avatar
amitchandak
Super User
6 years ago

Try for total

calculate(countrows('30 days Survey'),not(isblank('30 days survey'[Rating])))

 

Change table and column name.