Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Niraj_vora0106
Helper III
Helper III

Creating Measures in Report

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.

3 ACCEPTED SOLUTIONS
nag_via
Frequent Visitor

Niraj_vora0106
Helper III
Helper III

@nag_via 

Thank you so much, I found it.

 

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

Niraj_vora0106_2-1687205950541.png

 

 

 

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.

View solution in original post

gauthamboppana
Solution Specialist
Solution Specialist

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

gauthamboppana_0-1687211039899.png



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!

View solution in original post

4 REPLIES 4
gauthamboppana
Solution Specialist
Solution Specialist

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

gauthamboppana_0-1687211039899.png



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
Helper III
Helper III

@nag_via 

Thank you so much, I found it.

 

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

Niraj_vora0106_2-1687205950541.png

 

 

 

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.

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...

 

nag_via
Frequent Visitor

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.