Excluding Data Subset From Measure

[cheid_4838]

I have a table that calculates long idle percentage (long idle time/engine run time).  I want to exclude those drivers that have  driven less than 100 miles per week.  I created a calculation shown below that would calculate the distance by driver and start week, then would calculate the percentage excluding those drivers with less than 100 miles per week.  For example all drivers the week of 12/22 have less than 100 miles.  In the first screenshot it shows a percentage of 19.9%, but in the second when I expand out the drivers there are no perecentages listed which is correct, but I would like to see the results in the first screenshot.   I would also like this logic to be used with a card and guage visual where there are no driver filters.  How can what I created below be modified to exclude drivers with less than 100 miles per week and still calculate the percentage at all hiercharies and regardless of the visual used?  Thanks in advance for your help. 

Long Idle Over 100 =

VAR _Distance = CALCULATE(SUM('Long Idle'[Distance]),

ALLEXCEPT('Driver LookUp','Driver LookUp'[DriverFullName]),

ALLEXCEPT(CalendarLookUp,CalendarLookUp[Start of Week]))

VAR _IDLE =  CALCULATE(DIVIDE(sum('Long Idle'[Long Idle Time (Hours)]),sum('Long Idle'[Engine Time (Hours)])))

RETURN

IF(_Distance >100,_IDLE,"")

[vanessafvg]

ideally for these kinds of questions it is better to provide some sample data with an example of your expected result.

[cheid_4838]

I can't get anything to post to show you what I am trying to accomplish.  Ultimately I just want to the long idle percentage to be adjusted when the driver has a weekly distance less than 100 miles.  One of the problems I am having is that if there is more than one date as shown in the table below and one of the columns has a mileage less than 100 the entire row is excluded.  I just want that one cell with mileage less than 500 to be excluded and the remaining rows staying within the table.   Below shows the mileage for each driver.  I can't figure out how to exclude the mileage less than 100 without impacting the entire row.