Forum Discussion
Using measures from multiple semantic models
Hii Testeri
Measures from different models cannot interact in the same visual unless they are in a single composite model. The supported solution is to create a new Power BI report using DirectQuery for Power BI datasets (composite model) and connect to all required semantic models. This creates a local model where you can define relationships (e.g., one master calendar table) and use measures from multiple models in the same visual. Without using a composite model, it is not supported.
You can use measures from different semantic models in a direct query mode in the same visual if you use a table that bridges the two. You can still use one of the dates table to relate to the other semantic model granting that that table includes all the dates between the two.