Filtered NPS showing 200$?

hey,

try simplifying that measure first, something like this should work: 

Calculated NPS =

Var primary2 = filter("primary", [NPS Score] <> Blank() )

Var Total = count("primary2"[NPS Score])

Var PBenefecators = (calculate(count(primary2[NPS Score]), primary[NPS Score] >=8)) / Total

Var PDetractors = (calculate(count(primary2[NPS Score]), primary[NPS Score] <=6)) / Total

return PBenefactors - PDetractors

this should work, 

f this solved your problem please mark it as solution for others to find more easily, if you liked the solution give some kudos.