cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
marcgiag Visitor
Visitor

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 

2019-03-21_14-46-09.jpg2019-03-21_14-58-28.jpg

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Calculating NPS

Hi @marcgiag 

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Calculating NPS

Hi @marcgiag 

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.