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  Tota...
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,

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,