When you are adding a calculation to a table (see graphic below) and choose Single, to which of the following is the new column added?

When you are adding a calculation to a table (see graphic below) and choose Single, to which of the following is the new column added?

A . Selected dimension member
B . Every dimension member
C . @Data model
D . Story repository

View Answer

Answer: A

Explanation:

When you are adding a calculation to a table, you can choose from two options: Single or Multiple. The option determines how many new columns are added to the table based on the calculation.

The options are:

Single: Adds one new column to the table with the calculation result for the selected dimension member. For example, if you select Soft Drinks and choose Single, you will get one new column with the calculation result for Soft Drinks only.

Multiple: Adds multiple new columns to the table with the calculation result for each dimension member. For example, if you select Soft Drinks and choose Multiple, you will get three new columns with the calculation result for Soft Drinks, Juice, and Alcohol.

Therefore, the correct answer is Selected dimension member, as it is the option that the new column is added to when you choose Single. Verified

Reference: Create Calculations in Tables