Can I consolidate Measures from multiple tables into a single table for better organization?

[boldwake]

Hi Super Users,

I"m hoping that one of you has a someowhat easy slotion to the mess i've made for myself.  I've been using PowerBI for 3 weeks (maybe) and as I absolutely love it but I've learned a few lessions the hard way and hope I can avoid it this time. 

Is there a way to consolidate all of your measures into a single table.  As measures reference th erelvenat tables and columns, where they are organized seems pretty arbitrary and I'd like to now move them all into one giant "Measure" table so that i can more easily find and access them. but I can't figure out how to do this.

As an example

Here is my current state:

1. Table 1 (Unique key, Column A, Column B, Column C,....Measure 1, Measure 2, Measure 3)

2. Table 2 (Unique Key, Column D, Column E, Column F, Measure 4, Measure 5,.....Measure 15)

Ideal Future State

1. Table 1 (Unique key, Column A, Column B, Column C,...)

2. Table 2 (Unique Key, Column D, Column E, Column F)

3. NEW Measure Table (Measure 1, Measure 2, Measure 3, Measure 4, Measure 5....Measure 15)

Thanks

Blake

[Anonymous · Accepted solution]

I'm finding that a separate Measures table is useful, particularly during development when things change, tables get recreated etc. - see these threads for more discussion:

 http://community.powerbi.com/t5/Desktop/Measures-in-a-separate-table/m-p/91179#M38478

https://community.powerbi.com/t5/Desktop/How-to-keep-the-model-tidy/m-p/76587#M31910

To move a measure to a different table, highlight it then change the Home Table under the Modelling tab.

[Greg_Deckler]

The short answer is yes. Some people essentially create a blank query called "Measures" where they put all of their measures.