Forum Discussion

PBI_VL's avatar
PBI_VL
Regular Visitor
3 months ago
Solved

Use measures from another semantic model

Hello,   I have a measure that calculates number of clients in a semantic model. I want to use this measure in another model. I have made a connection with DirectQuery to the model and now have the...
  • Kedar_Pande's avatar
    3 months ago

    PBI_VL 

     

    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.

  • v-sgandrathi's avatar
    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.

  • cengizhanarslan's avatar
    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.