Calculating NPS

[Anonymous]

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

[v-cherch-msft · Accepted solution]

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,