Forum Discussion

birdie29's avatar
birdie29
Advocate II
9 years ago
Solved

ALL EXCEPT Help

Hi There   The following column should return 'Yes' if all the 'Engaged Answer' rows state '1' for a particular 'Worker' however as you can see below this isn't the case:     I think the i...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

birdie29

 

Did you get it to work?

birdie29's avatar
birdie29
Advocate II
9 years ago

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!