Forum Discussion
Use measures from another semantic model
- 3 months ago
Yes, but with limits. Cross-model filtering via DirectQuery to a semantic model only works if the filter field exists in the source model or you pass it through a shared dimension.
- 3 months ago
Hi PBI_VL,
Thank you Kedar_Pande for your point inthis query.
Here's an additional point that might be useful: filters from the new semantic model won't automatically apply to the remote measure unless there's a valid relationship path or the filter columns originate from the source semantic model.
In composite models that use DirectQuery to another Power BI semantic model, cross-model filtering is more limited compared to imported models. This means certain slicers, such as Year, may not impact the measure unless the dimension is shared or comes from the original model.
Thank you and Continue using Microsoft Fabric Community Forum.
- 3 months ago
Yes, this is possible. When you connect via DirectQuery to another semantic model, bring in the dimension tables (e.g. your Date table) as well, and use those fields in your slicers and filters. The filter context from the local report propagates through the DirectQuery connection to the source model, so filtering by year in your new model will correctly filter the referenced measure.
Yes, this is possible. When you connect via DirectQuery to another semantic model, bring in the dimension tables (e.g. your Date table) as well, and use those fields in your slicers and filters. The filter context from the local report propagates through the DirectQuery connection to the source model, so filtering by year in your new model will correctly filter the referenced measure.
Thank you. I have used this solution and this solves my problem.