Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
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
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |