Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filtered NPS showing 200$?

I have an NPS score being calculated which works fine under normal circumstances. Once I add a filter to look at a specific service line, the value changes to 200% and I cant figure out how the calcu...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
5 years ago

Hi, Anonymous 

 

You may try the following measure to see if it works.

 

Calculated NPS =
VAR _participantAdvocates =
    CALCULATE (
        COUNTROWS ( 'Primary' ),
        FILTER (
            ALL ( 'Primary' ),
            'Primary'[NPS Score] >= 9
                && 'Primary'[NPS Score] <> BLANK ()
        )
    )
VAR _participantDetractors =
    CALCULATE (
        COUNTROWS ( 'Primary' ),
        FILTER (
            ALL ( 'Primary' ),
            'Primary'[NPS Score] <= 6
                && 'Primary'[NPS Score] <> BLANK ()
        )
    )
VAR _totalParticipantResponses =
    CALCULATE (
        COUNTROWS ( 'Primary' ),
        FILTER ( ALL ( 'Primary' ), 'Primary'[NPS Score] <> BLANK () )
    )
RETURN
    DIVIDE (
        _participantAdvocates - _participantDetractors,
        _totalParticipantResponses
    )

 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.