Forum Discussion
Monthly Count Measure not Calculating properly
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!
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
3 Replies
- dedelman_clng
Community Champion
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?
v-danhe-msftMicrosoft Employee
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
- 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
