Multiple Date Columns and USERELATIONSHIP

Hello, everyone!

I am currently helping out my spouse with a Power BI dashboard for her work. She has a table that she cannot modify the columns of due to rules restrictions.

I've made and shared a copy of the important columns from the Excel giving me issues here.

I also made a simplified copy of the Power BI file.

It goes like this:

1. Client: I use it for some charts, but none that are causing my issues. I included it since it's basically an ID.
2. ID: Same as above.
3. Worker: Used in some charts for filtering purposes when trying to see data from the different workers involved.
4. Date Received: Not the primary date column for metrics, BUT used for any status that is not "Completed".
5. Type: The different services/tasks done by the workers. This is what she needs to count depending on which date applies. You could say it's the primary column for keeping track of each task. It should be filtered by the selected Status, Worker, and always have the most up-to-date information available, with the following date columns in priority order: Date of Cancellation, Date Completed, Date of Service, or Date Received.
6. Date of Service: This always happens ON or AFTER Date Received. Basically, it's the date in which the Client was offered the service Type.
7. Date Completed: This is when the service Type is finished. This is the date used for keeping track of KPIs for the fiscal year and is also THE primary date range used in the Power BI dashboard.
8. Date of Cancellation: Whenever a service Type is cancelled, this date is entered. It's impossible to have a Date Completed AND a Date of Cancellation. This Date is important when counting the number of Cancelled found in the Status column.
9. Status: The current status of each service Type. This is used in one of the column charts to filter different things on different charts.

My issue is that, for example, if a Type's Status is currently "In Progress", then it has no Date Completed, even though that is the primary Date column we use for the dashboard. This happens pretty much to any Type that has no Date Completed. Therefore, if in the date filter I have a date range that doesn't include any other dates other than Date Completed, the Status isn't displayed.

I've read that USERELATIONSHIP might help me with this issue in a basic way, but I am not sure how to use it or if it's the best way to do it.

How can I make it so that I can use all of the associated dates when necessary while keeping Date Completed as the primary one?