Creating Table from Different Columns

[Anonymous]

I have a table that references 3 different datasets:

I have created a relationship between these 3 data sets based on the 'EMS AM' column. The other columns are all calculated measures.

Active Count-> Delta Account dataset

Retention-> Delta Account dataset

NPS-> EMS NPS 2 dataset

Satisfaction-> EMS Feedback 2 dataset.

Rather than doing things this way, is there any way to get these measures to exist in a table of its own?

[Anonymous · Accepted solution]

Hey @Anonymous,

Yep, click on the enter data button and then enter in a random cell of data. I normally name this table "MeasureTable." Then I just create all of my measures by right clicking this table and selecting "New measure." If you've already created the measure and want to move it to your new MeasureTable, click on the measure and then go to the modeling tab and click on the "Home Table" dropdown and select your MeasureTable.

Hope this helps,

Parker