cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Moves Measures from One table to another

Hi,

I have around 60 measures under one table. Now, i want to Move all these measures to another table and delete previous table. How do i do that.

12 REPLIES 12
DavidVW
Frequent Visitor

Unfortunately, moving a measure to a new home table does NOT update measures that reference the moved measure. They continue to reference the moved measure's old home table. Each dependent measure must be MANUALLY changed to reference the new home table. Major disappointment.

semiitpro
Helper I
Helper I

This was a HUGE pain.  We built a measure table but the excel power bi tool couldn't handle this and we were forced to move the measures to data tables.   We use the home table feature but now the measures show up in BOTH tables.  We couldn't delete the original table because there was an exclamation point icon (figure this means power bi had a problem).  We had to delete each measure and the table would then dissapear and we had to save/close/reopen to delete the next measure.   ZERO stars for microsoft - this ended up being an entire DAY OF WORK.

Tahreem24
Super User
Super User

@Anonymous ,

 

Select your measures --> Go to modelling tab --> Under Property option on top --> Home Table --> Use drop down option in Home table to switch to different table.

 

Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis
Anonymous
Not applicable

Cant do multiselect for measures

 

Hi @Anonymous ,

I found a way to select multiple measures. Hold the Ctrl key in the Model view to select multiple measures, and then drag the selected measure directly to the Table you want.

31.PNG

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This is an actual lifesaver!

Not working for me !

This used to work for me but no longer does

this feature rocks.  Love it!

@Anonymous ,

 

No, I haven'e seen such feature.

 

Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , and Fortune 500 Companies Analysis

As far as i know it's not possible to bulk move measures between tables

Gordonlilj
Solution Sage
Solution Sage

Hi,

 

You can move measures using the home table

 

Updated ribbon

Capture2.PNG

 

Old ribbon

Capture.PNG

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

Power BI Dev Camp Session 25 with aka link 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, August 25 at 11a PDT for a great session with Ted Pattison!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors