Service recall rate measure

Hi jhowe1 ,

I think a lot of the problem stems from the way the data is related, to me the booking is the fact, given the relationships, so I added the asset and closed on keys to the booking table, then created a calc column that identifies if the booking is a recall

Recall Rate Flag = 
VAR _closed_on = Booking[Closed_on]
VAR _closed_minus_7 = DATE(YEAR(Booking[Closed_on]), MONTH ( Booking[Closed_on] ), DAY (Booking[Closed_on])) - 7
VAR _customer =  ( Booking[KEY_Customer] )
VAR _asset =  ( Booking[KEY_Asset] )
VAR _engineer =  ( Booking[KEY_Engineer] )
VAR _booking =  ( Booking[KEY_WorkOrder] )
RETURN
    if(CALCULATE (
        COUNTROWS ( Booking ),
        FILTER(
            ALL( Booking ),
              _asset <> -1
              && Booking[Closed_On] < _closed_on
                && Booking[Closed_On] >= _closed_minus_7 
                && Booking[KEY_Asset] = _asset
                && Booking[KEY_Customer] = _customer
                && Booking[KEY_Engineer] = _engineer
        )
    )>0, 1)

Then created a measure that counts the bookings that are recalls

Recall Rate New = sum('Booking'[Recall Rate Flag])

 which results in the image below, you may need to scrub the data a little on the way in to ensure that you have a one to one on the workorder and booking.

I can attach the file here or send to you through private message, your choice.

Thanks