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.
It makes perfect sense. Sorry for not picking it up earlier. I spend some time to come up with this.
Fully Engaged =
IF(CALCULATE(SUM(Test1[Engaged answer]);VALUES(Test1[Worker]);FILTER(ALLEXCEPT(Test1;Test1[Q#]);CALCULATE(COUNTROWS(Test1);Test1[Engaged answer]<>0)))=COUNTROWS(Test1);"Yes";"No")
Try it out and see if it has the right dynamic. If it solves your issue don't forget to give kudos and accept a solution.
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.