SAP Knowledge Base Article - Public

3602029 - Count operation only counts the distinct value of the selected dimension in SAP Analytics Cloud(SAC).

Symptom

Count operation counts the distinct value of the selected dimension in SAP Analytics Cloud(SAC).

Environment

SAP ANALYTICS CLOUD 2025.1.14 

Reproducing the Issue

  1. Log on to SAC
  2. Open story and add table widget
  3. Add a calculation for Count at 'X' dimension

Notice: the count operation gives the distinct count value for 'X' dimension.

Cause

  • This is by design behavior of the product.
  • Count function counts the number of the distinct values present the selected dimensions with values for a specific measure, including null values.

Resolution

Create an enhancement request if you want to request showing of repetitive members with count function. Refer KBA: 2424376 How do you create an enhancement request and provide feedback for SAP Analytics Cloud? 

See Also

Keywords

Sap Analytic cloud, SAC, Count, aggregation, measure, dimension , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Problem

Product

SAP Analytics Cloud all versions