Resolution
Scenario 1: Grand totals are blank for the discrete measure
Recreate the view using [Measure Names] and [Measure Values]. The attached example workbook starts from the worksheet "Scenario 1" to demonstrate the following directions:
- Remove [Profit Ratio] from the Rows shelf
- Double-click [Profit Ratio] in the data pane
- Tableau Desktop automatically moves both measures to the Measure Values card and adds [Measure Names] and [Measure Values] to the view
Scenario 2: Error "Cannot turn on Grand Totals for discrete measures"
Convert the discrete measure to the dimension. The attached example workbook starts from the worksheet "Scenario 2" to demonstrate the following directions:
- Select Analysis > Create Calculated Field
- In the Calculated Field dialog box that opens, do the following, and then click OK:
- Name the calculated field. In this example, the calculated field is named "Profit Ratio (LOD)"
- In the formula field, create a calculation similar to the following:
- { FIXED [Segment] : [Profit Ratio] }
- Right-click [Profit Ratio (LOD)] in the data pane and select Convert to Dimension
- Replace [Profit Ratio (table calc)] with [Profit Ratio (LOD)] on the Rows shelf
- Navigate to Analysis > Totals > Show Row Grand Totals