Kristinn Thor Sigurjonsson on 29 Jun 2017 20:00:22
I am restructuring a report that consist of 20 tables (and measure groups) I need to create new tables and move existing measures to that new table - essentially creating a measure group with measures that relate to each other.
Now I can do this by copying the measure formula, delete the old and paste as a new measure in the new table. Then I need to find all visuals where the measure was used and fix that - this can be done more efficiently.
I would like to be able to move a measure from one table to another - dag between tables or click "Move" and select a new location.
- Comments (7)
RE: move measures to new table
Hi! Changing the home table of a measure by selecting the measure and going to the Modeling tab and changing the Home Table to the appropriate table is not working for me on a live data connection. It worked when I was linked to a static Excel data source. Is there a workaround for when you are connecting to a live data source, say via azure / Sql? I made a copy of a previous, nearly identical file and am hoping to avoid having to go through and make copies of each individual measure, when the changes are so minimal, and I can just move them underneath the correct table in my fields. Any info is appreciated!
**perhaps there is another reason outside of the data source for why this does not work for me, so any ideas welcome!**
Thanks!
RE: move measures to new table
'@Mohammad AI-Salman Thank you. It works perfect!
RE: move measures to new table
Yeah - you can go through the maddening process of moving each measure individually, but what is lacking here (and is the point of "efficiency" in Kristinn's suggestion) is a quick way to move multiple measures at once.
RE: move measures to new table
it is already there ...
https://www.wiseowl.co.uk/blog/s2537/move-measure.htm
RE: move measures to new table
This is the basic feature that every application should have. Pls add it in next release
RE: move measures to new table
Great tip @John Schown - works a treat and solves practically all this request. Even if the charts break, you can update the formula (ie probably has old table name referenced) and the charts works again! Auto updating any old table names inside formulas is unfeasible I believe, as PowerBI can't always be sure of new one.
RE: move measures to new table
You can change the home table of a measure by selecting the measure and going to the Modeling tab and change the Home Table to the appropriate table.