Forum Discussion
ALL EXCEPT Help
birdie29 Sorry for the late answer.
Alright. This DAX formula should give you the desired result.
Percentage of engaged workers = IF(CALCULATE(COUNT(Test1[Engaged answer]);Test1[Engaged answer]=1)/CALCULATE(COUNT(Test1[Engaged answer]))=BLANK();0;CALCULATE(COUNT(Test1[Engaged answer]);Test1[Engaged answer]=1)/CALCULATE(COUNT(Test1[Engaged answer])))
Let me know if it works out for you.
Hi Anonymous
Thank you for spending so much time on this, I really appreciate it.
Unfortunately I'm getting an error message, please see below:
Don't worry about it. I love to help out.
Are you trying to create it as a column? Try creating it as a measure and see if it works out!
Hi Anonymous
Yes I was trying to work it as a column but now it's a measure it works!
What I now want to do with this measure is have a calculation that shows me the percentage of workers who are 'Fully Engaged' "Yes". ie if I select #Q 1-7 what percentage of the workers answered "Yes" to all of them?
I'm sorry for all the questions but in solving my question it's made me think more about what I want to do!
Thank you once again
Chris
birdie29 Sorry for the late answer.
Alright. This DAX formula should give you the desired result.
Percentage of engaged workers = IF(CALCULATE(COUNT(Test1[Engaged answer]);Test1[Engaged answer]=1)/CALCULATE(COUNT(Test1[Engaged answer]))=BLANK();0;CALCULATE(COUNT(Test1[Engaged answer]);Test1[Engaged answer]=1)/CALCULATE(COUNT(Test1[Engaged answer])))
Let me know if it works out for you.