Forum Discussion

Anonymous

Not applicable

7 years ago

How to store measures in separate table

I have a table that looks like this: CallID Attempt(s) ColdTrf(s) WarmTrf(s) Consult(s) 1 12 55 22 110 2 199 121 6 92 3 96 79 80 69 I have measures that work ou...

Resident Rockstar

7 years ago

Hi Anonymous,

If I understand your scenario correctly that you have created the measues that work out the standard deviations for each column (eg, attempt, cold, warm, consult) and you want to use the measures to create the a calculated table like the second table you post?

If it is, what is the SD column? Normally, if you want to create a calculated table, you could use SUMMARIZE function and create the table like below.

calculted table =
SUMMARIZE (
    'Tablename',
    "ID", 'TableName'[ID],
    "ColumnName1", [Measure1],
    "ColumnName2", [Measure2],
    "ColumnName3", [Measure3],
    "ColumnName4", [Measure4]
)

If you still need help, please share your measure formulas and explain what's the logic of the SD column in the calculated table so that I could have a test and share the expression to you.

Best Regards,

Cherry

Anonymous

Not applicable

7 years ago

Hi v-piga-msft

Yes your solution does partly work, however as I have calculted the 2nd Standard deviation per column also, this will need to be added to the calculated table also.

See below:

Basically I need to add a new row underneath "SD1", as "SD2" with the associated SD2 measures. Looks like the Summarize function only allows you to add one row per column.

Any ideas?

v-piga-msft
Resident Rockstar
7 years ago
Hi Anonymous ,

Sorry for the delay.

Does first row of SD1 calculate the standard deviations for each column for the table in your first reply?

What is the 2nd Standard deviation per column? Doest the 2nd Standard deviation reference the column in another table?

If it is, I'm afraid that you should create another summarize table and then use UNION function to achieve your desired output.

Table = UNION('Table2','Table3')

In addition, you could write the measures in summarize table directly.

Best Regards,

Cherry
v-piga-msft
Resident Rockstar
7 years ago
Hi Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry