Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculating NPS

Hi There,

I am trying to caculate my NPS score. I have a column called NPS_RANK that has provides a count of 

I am trying to find a Power BI formula that will do the following math 

Total responces (572)

% of responces that are Promoters (412/572= .72)

% of Responces that are Detractors (104/572 = .18)

 

Promoters - Detractors (.72-.18 = .54) x 100 = NPS SCORE (54)

 

Any help would be so appreciated

Marc

 

 

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may create measures like below:

    % Detractors =
DIVIDE (
    CALCULATE (
        COUNT ( Table[NPS_Rank] ),
        FILTER ( Table, Table[NPS_Rank] = "Detractors" )
    ),
    COUNTROWS ( Table )
)

    % Promoters = DIVIDE(CALCULATE(COUNT(Table[NPS_Rank]),FILTER(Table,Table[NPS_Rank]="Promoters")),COUNTROWS(Table))
    NPS SCORE = ([% Promoters]-[% Detractors])*100

    Regards,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous 

    You may create measures like below:

    % Detractors =
DIVIDE (
    CALCULATE (
        COUNT ( Table[NPS_Rank] ),
        FILTER ( Table, Table[NPS_Rank] = "Detractors" )
    ),
    COUNTROWS ( Table )
)

    % Promoters = DIVIDE(CALCULATE(COUNT(Table[NPS_Rank]),FILTER(Table,Table[NPS_Rank]="Promoters")),COUNTROWS(Table))
    NPS SCORE = ([% Promoters]-[% Detractors])*100

    Regards,