DAX Measures in SSAS Tabular Model or PBIX Report File?

[blynchdata]

Hello,

I tend to test DAX measures in a local report file and then graduate them to the centralized SSAS model for organization, ease of administration and re-use in other reports. 

The number of DAX measures in the model is growing quite quickly. One reason is that we do not have access to Calculation Groups yet (we are on SQL Server 2016), but also because I am keeping all DAX measures centralized in the model. 

How do you decide where to input your DAX measures, in the model or only in the PBIX report file?

Thank you for your help.

[amitchandak · Accepted solution]

@blynchdata , I think to keep them in the model. That will keep it centralized and can be shared across various pbix

https://www.ironsidegroup.com/2019/05/21/power-bi-ssas-tabular-modeling-essentials/

[amitchandak · Accepted solution]

@blynchdata , I think to keep them in the model. That will keep it centralized and can be shared across various pbix

https://www.ironsidegroup.com/2019/05/21/power-bi-ssas-tabular-modeling-essentials/

[blynchdata · Accepted solution]

Thank you!