topic Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse in Data Engineering

Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

dab111 — Sat, 21 Sep 2024 22:36:24 GMT

I am completing this tutorial: https://learn.microsoft.com/en-us/power-bi/fundamentals/fabric-get-started#add-a-data-destination

When i get to the step to write a measure: https://learn.microsoft.com/en-us/power-bi/fundamentals/fabric-get-started#write-a-measure-in-dax i can not see the tools tab or the measure function shown in the tutotial :

This is what i can see:

As you can see there is no tools tab on the ribbon or measure functionality.

Would anyone be able to help with this?

Thanks

Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

suparnababu8 — Sun, 22 Sep 2024 04:45:47 GMT

Hi @dab111

I think Microsoft updated the UI part. Microssoft people continuesly updataing the Power BI/ Fabric UI on regular basis. That's why you are not found New Measure.

Any way, still there is a option to create a measure, pls see the below snapshot

1. Click on ellipsis(...) on the table where you have to create measure.

2. Then click on 'New Measure', If you want to create a DAX measure.

3. If you want to create 'Calculated Column' then click on that option.

Hope this helps you.

Thanks!

Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

tharunkumarRTK — Sun, 22 Sep 2024 06:17:55 GMT

@dab111

I guess you opened default dataset (semantic model). Open reporting tab and click on manage semantic model and then select the tables which are necessary and un select the remaining tables. Then click on confirm, on the left navigation pane and you shoud be abel to see the 'New Measure' option.

I verified this option in two fabric tenants and I can see the 'New Measure' option

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

Anonymous — Mon, 23 Sep 2024 02:45:39 GMT

Hi @dab111 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

dab111 — Mon, 23 Sep 2024 08:37:48 GMT

Hi, i still dont have all the options:

Thanks for your help

Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

dab111 — Mon, 23 Sep 2024 08:42:35 GMT

Hi, thanks for your help. When i follow your steps i still cant find measure:

Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

Anonymous — Tue, 24 Sep 2024 05:58:32 GMT

HI @dab111,

After you attach these table to the model, have you enter to the warehouse semantic model to check if these table successed added to the semantic model? (they may existed some delay to sync these tables to the model, you can wait some minutes and re-open the warehouse to refresh model tables)

I test and find these model operations(new measure/column) only existed when you semantic model existed model tables.

tables added to the model

after remove tables from model

Regards,

Xiaoxin Sheng

Re: Tools/measure tab is not available on the ribbon in sql endpoint on the lakehouse

dab111 — Tue, 24 Sep 2024 09:55:01 GMT

Hi @suparnababu8 @Anonymous @tharunkumarRTK Thaks for all your solutions. Today it seems to work, im not sure why or what seemed to be the fix as i tried all your solutions. I appreciate your help in finding a solution