cancel
Showing results for
Search instead for
Did you mean:
marcgiag 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  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

## Re: Calculating NPS

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

## Re: Calculating NPS

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.