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
That's a really good suggestion however we also need to know if the 'Worker' is 'Fully Engaged' based on only #Q's 1-12 also, however if I use your solution the score in this case would not come to 22 but only 12 and therefore become 'No' under the 'Fully Engaged' column.
Is there another solution you can think of?
Thank you
Chris
Whoops I missed that part. Given your information this should work.
Fully engaged = IF(CALCULATE(SUM(Test1[Engaged answer]);VALUES(Test1[Worker]);Test1[Q#]<=12)=12;"Yes";"No")
Does this solve it?
Hi Anonymous
Sorry I'm not being very clear. The 'Fully Engaged' response needs to be dynamic ie the user may select just #Q 1, 5 and 7 in which case if the 'Engaged Answer' for just these questions is '1' then I would want the formula to state 'Yes' regardless of what the response is for all the other questions.
Does that make sense?
Thank you
Chris
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: