Databricks in their Data+AI summit blogpost has mentioned something related to multi fact relationships.Richer semantic modeling: Go beyond single-table measures with multi-fact relationships (Public Preview in Dashboards), level-of-detail (LOD) calc...