Measure Optimization Help

Wow Anonymous thank you again for your thorough guidance ond offer to help on this!

I've tried to make the changes you suggested:

1. join fact tables in the Query Editor to reduce the number of relationships (i.e. instead of using relationships between RoughInspections and RoughAirBarrier, RoughAirSealing, RoughCustom, etc. they are joined at the query stage into a fact table, "RoughInspections_merged")
2. switch bi-directional relationships cross filter direction from "Both" to "Single" where possible (there are some where PBI says "the cardinality you selected isn't valid for this relationship" when I try to do this and I don't understand why)
3. use dimension tables to relate to fact tables for slicer use -- there are still a few fact-to-fact table relationships that I'm not sure how to properly fix

Still, after these changes, my "Rough Inspection Results" page takes between 50-60 seconds to update visuals when a slicer selection is made.  I've made an anonymous dataset and uploaded my Power BI file to Google Drive so others can access to review.  Note that I first made the changes you recommended to the "Rough" part of the dataset; there are a lot of measures to update so I wanted to see if I could improve the performance before editing the rest.  I deleted the relationships on the "Final" side so I could be sure that it wasn't those relationships slowing things down.

Please let me know if I can explain anything or if any part of my problem is unclear.  I'm hopeful that the performance of my report can be improved, but maybe I'm just asking too much of Power BI?  Thanks again to the Power BI community for helping a rookie like myself out!

Jonathan