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
brft
Frequent Visitor

Datamart - Can't Create New Measures

I have a datamart in Dev, Test, and Prod workspaces in a deployment pipeline.  I am trying to create a new measure in the Dev workspace, but I am unable to commit it.  I also don't get any suggestions when trying to compose it in the Model tab.  There is no error message, and commit is not greyed out, it simply doesn't do anything.  If I click out of the compose box, the measure either keeps the default "Measure =" or disappears entirely.  I have previously been able to create messages in the same datamart, but I cannot edit them now either.

3 REPLIES 3
v-yilong-msft
Community Support
Community Support

Hi, @brft

I created a datamart in Power BI Service based on your question, and I can create Measure in Home view, but I can't show it.

vyilongmsft_0-1705992670749.png

If you want to view the Measure created, you can do so under Reporting.

vyilongmsft_1-1705992670751.png

For your problem, I think the reason for not being able to create it may be due to the lagging of the web page, it may also be due to the dataset is too large caused by the Measure has a period of buffering time, you can also check to see if you entered the Measure code correctly, if all these can't solve your problem, I hope that you can provide me with more information on your question.

 

 

 

 

 

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yilong-msft

Thanks for the detailed test. I am able to create measures with no problem in other datamarts.  I had also thought maybe it was a buffering/lag issue, as the datamart in question is rather larger (this table has maybe 30k records, so not that big).  I tried to commit and leave the page for upwards of 30 minutes, but it didn't seem like it had an impact.  

 

I am also able to make the same measure on the same table in PBI Desktop, so I don't think it is a syntax issue.  I have also tested some very simple measures just in case.  For reference, the one I specifically want to create is 

% Registered Timely = CALCULATE(COUNTROWS('Deviation Records'), 'Deviation Records'[DV Registration Target] = 1)/COUNTROWS('Deviation Records')
 
PBI Datamart screensht.jpg
GilbertQ
Super User
Super User

Hi @brft 

 

It could be that there is an issue with the power of BI service. Sometimes this gets resolved typically in a few hours, which you could then try again. if this has not been working for a few days my next solution is to log a support ticket.





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors