Pros and Cons creating measures on Data model file and Report file

[sathishsam]

Hi Experts,

I am a new bee to PowerBI report and learning a lot day by day in this forum. I read somewhere that we need to split the Data model file and report file. So i created a Dataset file and Report file which uses live connection to Dataset file. Now, my biggest question is where are all the measures to be created. is it in Dataset file or Report file. According to your experience what are the pros and cons creating them on Dataset file or Report file.

Thanks in advance

[mariussve1]

Yes, I agree on creating measures on modell. Then this can be reused on multiple reports connected to the same model. It can be used by end users on the analyse in excel feature. We are also using Tabular Editor to maintain all the models, and then the measures need to be stored in the model.

Marius

[Shahfaisal · Accepted solution]

Best practice in general is to create measures in the model. If the measure is going to be used by other users in the organization, then create it in the model, however, if the measure is just a one-off type of calculation that is needed in one specific report or by a specific purpose then create it in the report.