cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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.

8 REPLIES 8
Highlighted
Super User I
Super User I

Re: Moves Measures from One table to another

Hi,

 

You can move measures using the home table

 

Updated ribbon

Capture2.PNG

 

Old ribbon

Capture.PNG

Highlighted
Super User III
Super User III

Re: Moves Measures from One table to another

@vamshik153 ,

 

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!!!
You can follow me on LinkedIn

Please take a quick glance at newly created report:
My Report
Highlighted
Helper V
Helper V

Re: Moves Measures from One table to another

Cant do multiselect for measures

 

Highlighted
Super User I
Super User I

Re: Moves Measures from One table to another

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

Highlighted
Super User III
Super User III

Re: Moves Measures from One table to another

@vamshik153 ,

 

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!!!
You can follow me on LinkedIn

Please take a quick glance at newly created report:
My Report
Highlighted
Solution Sage
Solution Sage

Re: Moves Measures from One table to another

Hi @vamshik153 ,

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.

Highlighted
Helper I
Helper I

Re: Moves Measures from One table to another

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.

Highlighted
Resolver I
Resolver I

Re: Moves Measures from One table to another

this feature rocks.  Love it!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors