If less than statement

Because you have rows where the value of [Projection Accuracy 2] is blank and PowerBI sees blank as < .08 so it gives you a 0.  You can change it to only return if [Projection Accuracy 2] is not blank.

Below Goal = 
VAR _ProjAcc = [Projection Accuracy 2]
RETURN
IF ( NOT ISBLANK ( _ProjAcc ), IF( _ProjAcc > .85, 1,0 ) )

Hi mmowrey ,

You could use SUMX() function.

https://docs.microsoft.com/en-us/dax/sumx-function-dax 

For example:

measure = sumx('table',[Below Goal])

Best Regards,

Jay

thanks so much .. this all worked.. one last question :)..   when i take sum then divide by another number why would it come up as 0

mmowrey , 7 / 18 = 0.3888. If your measure [Below Goal divided by Count of DriveID] is formatted as Whole Number or to 0 decimal places, then it will display as zero.