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.
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.
Hi Anonymous
Sorry for the late response, I did try it but I didn't get what I expected so I'm just working through it to understand it more first before coming back to you. Thanks for following up!
Hi birdie29,
Have you managed to solve this issue? If yes, could you accept helpful replies as solution to close this thread?
If you still have any question on this issue, feel free to post here. :smileyhappy:
Regards
