Forum Discussion
Post ProdigyNPS Calculation in BI
You should be able to do this with something like the following:
NPS Score = VAR _advocates = CALCULATE( COUNTROWS(Table), Table[Likely to Recommend] >= 9 ) VAR _detractors = CALCULATE( COUNTROWS(Table), Table[Likely to Recommend] >= 9 ) VAR _totalResponses = CALCULATE( COUNTROWS(Table ) ) RETURN DIVIDE( _advocates - _detractors, _totalResponses )
jcastr02 wrote:
How can we make it if, the NPS Score is 0 to show 0. Right now if the result is 0, the visual shows (blank).
Typically that would mean that the score is actually blank, but it is annoying how card visuals do not give you the option to display a 0 instead.
What I tend to do is to create a measure specially for cards that has something like =IF( ISBLANK( [NPS Score] ), 0 , [NPS Score] )
Generally this is not a good pattern as it forces a non-blank result which can hurt performance, but for visuals like cards it's OK.
Super UserYou should be able to do this with something like the following:
NPS Score =
VAR _advocates = CALCULATE( COUNTROWS(Table), Table[Likely to Recommend] >= 9 )
VAR _detractors = CALCULATE( COUNTROWS(Table), Table[Likely to Recommend] >= 9 )
VAR _totalResponses = CALCULATE( COUNTROWS(Table ) )
RETURN DIVIDE( _advocates - _detractors, _totalResponses )
jcastr02d_gosbell this worked, thanks so much. I am trying to just make it show as a whole number. I was playing with the formula to just multiply by 100 to move decimal over but keep getting errors. Any ideas?
- jcastr02
disregard, I found it!! thanks again
- jcastr02
d_gosbell How can we make it if, the NPS Score is 0 to show 0. Right now if the result is 0, the visual shows (blank).
- d_gosbell
jcastr02 wrote:
How can we make it if, the NPS Score is 0 to show 0. Right now if the result is 0, the visual shows (blank).
Typically that would mean that the score is actually blank, but it is annoying how card visuals do not give you the option to display a 0 instead.
What I tend to do is to create a measure specially for cards that has something like =IF( ISBLANK( [NPS Score] ), 0 , [NPS Score] )
Generally this is not a good pattern as it forces a non-blank result which can hurt performance, but for visuals like cards it's OK.