Help Creating a measure that is filtered by another measure

[Philfound1199]

I'm trying to create a measure that provides the percentage of shipments that meet a particular criteria. Specifically I want to divide the number of shipments whose average miles per shipment is  >=100 than the total number shipments.

Trying to use this DAX to get the count of shipments whose avg miles are >= 650

_shipments ex Shuttles IM Compatability =

CALCULATE(

    [Count of Shipments],

    NOT('Attributes'[Carrier SCAC] IN { "xxx", "xxxx", "xxxx" }), [Average Miles per Shipment]>=650)

getting this error

I think the issue I'm having here is that the count of shipments and the average miles per shipment are values coming from a SQL server so the count and average functions are not happening in power bi so the ability to filter is limited since those valuse are in seperate tables and not connected. If it's not possible thats fine but I would like some help understanding what the above error is actaully saying.

[Philfound1199]

I actually think I figured it out getting some help from this post Solved: DAX Filter - greater-than or equal is not working - Microsoft Fabric Community

So instead of:

_shipments ex Shuttles IM Compatability =

CALCULATE(

    [Count of Shipments],

    NOT('Attributes'[Carrier SCAC] IN { "xxx", "xxxx", "xxxx" }), [Average Miles per Shipment]>=650)

Using

_shipments ex Shuttles IM Compatability =

CALCULATE(

    [Count of Shipments],

    NOT('Attributes'[Carrier SCAC] IN { "xxxx", "xxxx", "xxxx" }), FILTER(Attributes, [Average Miles per Shipment]>=650))

So adding that filter function with the table instead of just the measure.