cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
birdie29 Regular Visitor
Regular Visitor

Re: ALL EXCEPT Help

Hi @ValubiMartin

 

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

ValubiMartin Senior Member
Senior Member

Re: 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.

ValubiMartin Senior Member
Senior Member

Re: ALL EXCEPT Help

@birdie29

 

Did you get it to work?

birdie29 Regular Visitor
Regular Visitor

Re: ALL EXCEPT Help

Hi @ValubiMartin

 

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!

 

Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: ALL EXCEPT Help

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. Smiley Happy

 

Regards

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 45 members 941 guests
Please welcome our newest community members: