Reply
Highlighted
Frequent Visitor
Posts: 10
Registered: ‎12-07-2018
Accepted Solution

Monthly Count Measure not Calculating properly

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

 

Capture.JPG

 

 

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!


Accepted Solutions
Community Support Team
Posts: 2,061
Registered: ‎06-24-2018

Re: Monthly Count Measure not Calculating properly

Hi @awilliams91,

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

1.PNG

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Attachment

All Replies
New Contributor
Posts: 450
Registered: ‎08-25-2016

Re: Monthly Count Measure not Calculating properly

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?

 

Community Support Team
Posts: 2,061
Registered: ‎06-24-2018

Re: Monthly Count Measure not Calculating properly

Hi @awilliams91,

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

1.PNG

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Attachment
Community Support Team
Posts: 2,061
Registered: ‎06-24-2018

Re: Monthly Count Measure not Calculating properly

Hi @awilliams91,

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.