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

[dab111]

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

[dab111 · Accepted solution]

Hi @suparnababu8  @v-shex-msft @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 

[v-shex-msft]

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

[tharunkumarRTK]

@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!

[dab111]

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

[v-shex-msft]

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

[suparnababu8]

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!

[dab111]

Hi, i still dont have all the options:

Thanks for your help