Anand Power BI User on 08 Apr 2024 04:48:26
Hi,
I think it would be good to have re-usable/ write once measures in Semantic Models for Fabric Warehouse and Lakehouse.
This will help to centalise business logic once (similar to data) and not duplicate/write the same measures in every Semantic Models that needs it.
Since we can write a measure against a table in Warehouse and Lakehouse (SQL endpoint), if the Semantic models that use that table can inherit the measures as well, that will avoid duplication of the same measure.
Centralising business logic in measures will be a great benefit to organisations.
I understand the relationships in the model can cause issues for measure behaviour. But the responsibility of the data modeller and understanding how and when the measure can be used.
Since measures can hidden from end user tools, if the data modeller can hide the measure if it is not relevant for the model.
Thanks,
Anand