Forum Discussion
antoher newbie question
Hello!!
I have a question, which for sure will be very easy. We send a survey with every sale, and I need to extract the satisfaction of these surveys.
In Qlik we have it with the formula
count({$<survey_response = {'5', '4'}>} ID_sell / count({$<survey_response = {'1', '2', '3', '4', '5'}>} ID_sell)
How can I do it in DAX?
MEASURE =
DIVIDE(
CALCULATE(COUNTROWS('Table'), 'Table'[survey_response] IN {4,5}),
CALCULATE(COUNTROWS('Table'), 'Table'[survey_response] IN {1,2,3,4,5})
)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
3 Replies
- SpartaBI
Community Champion
MEASURE =
DIVIDE(
CALCULATE(COUNTROWS('Table'), 'Table'[survey_response] IN {4,5}),
CALCULATE(COUNTROWS('Table'), 'Table'[survey_response] IN {1,2,3,4,5})
)
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI- SpartaBI
Anonymous my pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543