Power Bi DAX: Percentage is not showing the correct value and Need help with formulas to get %

[paulfink]

I have a table that shows the hours worked for the month.

I needed to make a percentage that shows the amount of people that have worked equal to or greater than the standard for the month. I did that by having:

Equal or greater Standard = DIVIDE(DISTINCTCOUNT('4 LastMeeting'[Project Lead]),
CALCULATE([Worked]>=[Standard]), BLANK()) / 100

Which showed in the table as 0.1 so i could make it a % when it is a total which worked. But i also need when a % of people who worked below the standard which should just be changed the >= to < in the CALCULATE([Worked]>=[Standard]) which it did show in my table but the total is showing as Blank.

Also, my 45% is showing for the entire data and is not being filtered by date. Any ideas how i can improve the Equal or greater Standard forumla? 

Any ideas how i can change my formula to show as 0.1 for hours worked that is below the standard?

Below Standard = DIVIDE(DISTINCTCOUNT('4 LastMeeting'[Project Lead]),
CALCULATE([Worked]<[Standard]), BLANK()) / 100

[amitchandak]

@paulfink 

Can you change it like

Equal or greater Standard = DIVIDE(DISTINCTCOUNT('4 LastMeeting'[Project Lead]),
CALCULATE(if([Worked]>=[Standard]), BLANK(), ?)) / 100

review what should come in place of blank and ?

[paulfink]

it came out as the same, 38% on the table but 45% on the card. Could you make an entirely new measure??

[dax]

Hi @paulfink , 

I am not sure which part cause this problem, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[paulfink]

Hi @dax , i need to make a measure that shows the overall % of people that have worked equal to or greater than the standard and if they have worked below the standard (2 different measures as seen in my original post). The way i have done it is show as 1 if worked equal to or greater than the standard and if they have worked below the standard. I have divided it by 100 so i could change it to a % and make a total but it is not doing that. I have 38 people but 19 are equal to / greater and 19 are below the standard so they should both be 50%.

My standard is

Standard = CALCULATE( SUM('0 Calendar'[Networkdays]) * 8, 
FILTER('4 LastMeeting', '4 LastMeeting'[Date] = LASTDATE('4 LastMeeting'[Date])))

It is based off the calendar table and is filtered by my data's dates and it works.

Its just the summary measures that arent working, could you help me and change them a bit or make new formulas for me?