Creating Measures in Report

[Niraj_vora0106]

Hi community,

Hope you all are doing well.

I have a doubt regarding Power BI Service.

I know there's an option to Create a report in Power BI Service via Excel or an already published Dataset.

we can create visuals, and apply aggregations but can we create measures in the report? that's my main concern

Because I tried everything but couldn't find an option to create a measure in the Power BI Service report.

Please help.

[Anonymous · Accepted solution]

Hello,

I think you need to activate Edit Data model in Power bi service

https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-models

[Niraj_vora0106 · Accepted solution]

@Anonymous 

Thank you so much, I found it.

But I've 1 doubt regarding this, hope you can help me out there.

why is the Open model option not activated? in few datasets it was activated and I could create measures, but why not in this one??

I've activated the Edit option too in workspace settings.

[gauthamboppana · Accepted solution]

@Niraj_vora0106  - In the workspace settings, you need enable the option "User can edit the data models in Power BI Service". Hope this helps. 

Did I answer your question? Mark my post as a solution! 

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

[Niraj_vora0106 · Accepted solution]

@Anonymous 

Thank you so much, I found it.

But I've 1 doubt regarding this, hope you can help me out there.

why is the Open model option not activated? in few datasets it was activated and I could create measures, but why not in this one??

I've activated the Edit option too in workspace settings.

[Anonymous]

Have you looked at the limitation section to see if you match any of these: https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-models#unsupported-data...

[Anonymous · Accepted solution]

Hello,

I think you need to activate Edit Data model in Power bi service

https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-models