Skip to main content

Known Issues and Limitations

This section describes limitations and known issues related to dimension calculation groups.

Tableau formatting limitation​

Tableau allows workbook designers to control Numeric Formatting options for measures, not table columns or rows. Consequently, a singular measure formatting option is applied to all metric values produced by a calculation group, effectively ignoring the formatting defined in AtScale.

To work around this limitation, it is recommended that you change the calculation name in AtScale from "Percentage" to "Fraction". This way it should be more clear to the report audience that they are not viewing percentages.

If you are willing to hide the non-percentage calculations, you can do this in Tableau in the following way:

  1. Use the Filters panel to uncheck all non-percentage calculations from the Calculation Group.

  2. For Floating Point measures:

    1. Click on the Measure Value's pill and select "Format" from the context menu to expose the Formatting form.
    2. In the "Numbers" select list, choose "Percentage".

  3. For Integer measures:

    1. Follow the Floating Point measures steps above.

    2. Click on the Measure Value's pill and select "Measure ()" and choose "Average".

      This will cause Tableau to treat the integer value as a floating point number, and apply the formatting set in the previous step.

As a reminder, non-additive metrics, such as Count Distinct metrics, do not produce visually additive subtotals or grand totals. As a result, formatting these metrics as percentages will result in subtotals and grand totals that do not equal 100%.

DOC-1097

Formatting dimension calculation groups in Power BI​

Power BI ignores the Calculation Format String specified in a calculation group calculation. For example, if the format string is set to Percent for the Pct of Total calculation, the expected result is that Power BI displays the value multiplied by 100, rounded to the desired number of decimal places, and shown with a % symbol. Instead, Power BI displays the unformatted floating point value.

In this case, it is recommended that the calculated member's expression be customized by multiplying by the desired factor and edit the member's display name to include the % symbol.

ATSCALE-13317

Query limitation​

You should use only one dimension calculation group in a query at time. Using more than one would result in either empty results or a query error.

DOC-1111

Performance recommendation​

The run-time duration of queries using calculated dimension groups is directly proportional to the type and number of calculations defined in the calculation group. Therefore, it is recommended to limit the number of calculated members in a single calculation group to no more than five.

DOC-1111