Monthly Count Measure not Calculating properly

[Anonymous]

I have a data model that houses data around customer survey results (see below).

Currently, I'm trying to get to the point where we can calculate our NPS. I've created a measure to parse out the number of Promoters (response >= 9). 

=CALCULATE(COUNTA(Satisfaction_Data[How likely are you to recommend?]),FILTER(ALLEXCEPT(Satisfaction_Data,Satisfaction_Data[EoMonth],Satisfaction_Data[Svc Center]),Satisfaction_Data[How likely are you to recommend?]<=10 && Satisfaction_Data[How likely are you to recommend?]>=9))

However, the results of the count are incorrect. Instead of splitting the count by month, the expression is agregating all months together by svc center. In the example above, svc center ABC should have 5 promoters in November and 3 in December but DAX in aggregating all responses of >= 9 together (for a total of 8 over both months). Is there something specifically I'm doing wrong here? Thank you for the help!

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Could you have created a slicer visual in your report? You could use the slicer to choose the different group:

Regards,

Daniel He

[dedelman_clng]

When I replicate what you've shown in your post, along with the exact same code, I get what I assume are the desired results.

How are you trying to display the NPS?