Can Power BI manage centralized measures for use in different semantic models?

[CraftyCreator]

Hi everyone,

Is there a way we can manage measures at a centralised place in Power BI for use in different semantic models? We are planning on dividing our big Tabular Model into smaller semantic models. Some semantic models might contain the same measures. So rather then editing each measure in every semantic model we would like to have one central place to edit these measure and then have it automatically updated in all the semantic models. Furthermore this would also be best practise so all the KPIs in all the reports will have the same calculations and values. Is there a way to acchieve this somehow using Power BI or Fabric?

Thanks already in advance 🙂

[CraftyCreator]

We have not proceeded with creating Data Warehouses therefore I guess I can not accept the answer as solution as I do not have tested it. The approach we are currently trying is to use PBIP and TMDL to acchieve the desired outcome. But this feature is still pretty new from Power BI.

[v-vpabbu]

Hi @CraftyCreator,

Thanks @ibarrau  for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @CraftyCreator,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @CraftyCreator,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[ibarrau]

Hi. Well. I don't think you can do it with just PowerBi. You could copy paste measures opening two tabular editors connected to the Power Bi Desktops of both semantic models to make it easier.

The only thing I think I could solve it right now is using Fabric Data Warehouse. You can create measures in the warehouse tables. That way you could create smaller semantic models that will have the measure of the table when getting data from there.

I hope that helps,