Count filtered by measure and circular refrence

Hi Pmorg73 ,

Some things that will help you :
1) The attributes in house drill that are duplicated shouldn't belong in the house drill table.
Ex: Floor Area. Floor Area is probably an attribute of Job No and probably belongs in the Job No number
Other attributes that should probably be moved : Budget, Job State, Designer Complexity, Architect ...

2) Your biggest issue is how you handle your Size slicer. You need to change the way you use it. It would be

so much easier for you to create a calculated column in the Job No table that have the size.

Right now, what I ended up doing is adding a calculated column in the house drill.

Size = 
CALCULATE(
    MIN( 'Size slicer'[Size] ),
    FILTER(
        'Size slicer',
        'house drill'[Floor Area] >= 'Size slicer'[Lower] &&
        'house drill'[Floor Area] < 'Size slicer'[Upper]
    )
)

 3) You probably don't need the two calculated column for Budged per m and Billable per m.

I'll send you the pbix I modified in PM