Forum Discussion
Customer Satisfaction Analysis
Hi there, Thank you for taking interest in my subject. I have been struggling with this topic for weeks and I know there's a solution out there just to purchase "Dynamics 365" and download the "...
Hi Anonymous ,
I cannot work the excat same result as you need. Please check the following steps to work around.
1 Here I create measure as below to work on it.
count = COUNT('Table'[CSAT Score])Measure = MAX('Table'[CSAT Score]) * [count]Measure 2 = IF(ISFILTERED('Table'[CSAT Score]),BLANK(),DIVIDE(SUMX(VALUES('Table'[CSAT Score]),[Measure]),SUMX(VALUES('Table'[CSAT Score]),[count])))8%>VOC≤2 = CALCULATE([count],FILTER('Table','Table'[CSAT Score]<=2 && 'Table'[CSAT Score]>=0)) / CALCULATE([count],ALLEXCEPT('Table','Table'[Contact Center]))85%>VOC≥4 = CALCULATE([count],FILTER('Table','Table'[CSAT Score]<=5 && 'Table'[CSAT Score]>=3)) / CALCULATE([count],ALLEXCEPT('Table','Table'[Contact Center]))
Hi v-frfei-msft ,
Kindly find below link:
https://1drv.ms/x/s!Aq_wrQrmKgkyxyjlgZRNeOsc4sWw?e=a5fVjJ
You can find expected result in sheet "Expected result"
Thank you
Hi Anonymous ,
I cannot work the excat same result as you need. Please check the following steps to work around.
1 Here I create measure as below to work on it.
count = COUNT('Table'[CSAT Score])
Measure = MAX('Table'[CSAT Score]) * [count]
Measure 2 = IF(ISFILTERED('Table'[CSAT Score]),BLANK(),DIVIDE(SUMX(VALUES('Table'[CSAT Score]),[Measure]),SUMX(VALUES('Table'[CSAT Score]),[count])))
8%>VOC≤2 = CALCULATE([count],FILTER('Table','Table'[CSAT Score]<=2 && 'Table'[CSAT Score]>=0)) / CALCULATE([count],ALLEXCEPT('Table','Table'[Contact Center]))
85%>VOC≥4 = CALCULATE([count],FILTER('Table','Table'[CSAT Score]<=5 && 'Table'[CSAT Score]>=3)) / CALCULATE([count],ALLEXCEPT('Table','Table'[Contact Center]))
You are amazing! Thanks a lot, Frank