Hi User Please check below points
Verify the Calculated Measure Settings:
Go to the Calculated Measure settings.
Ensure that:
Operation is set to Average.
Aggregation Dimension is correctly set to Region.
Double-check that the measure used for the calculation is numeric and supports aggregation.
Review Chart Configuration:
Open the chart settings and ensure:
The chart type is appropriate for displaying averages (e.g., Bar, Column).
No conflicting aggregations are applied at the chart level.
The measure shown is the calculated measure you created.
Check the Model’s Aggregation Behavior:
Navigate to the Model in SAC and inspect the aggregation behavior of the base measure (e.g., Profit).
The default aggregation of the base measure (sum, average, etc.) should not conflict with the calculated measure.
Set Aggregation in the Chart:
In the chart designer:
Select the calculated measure.
Ensure that the aggregation is explicitly set to Average at the chart level.
Filter Settings:
Ensure that the filters applied to the chart or story do not inadvertently affect the calculation (e.g., Region filters might lead to unintended aggregation).
Use the Formula Editor:
If the predefined settings are not working as expected, use the Formula Editor to create a custom calculation for the average.
Example:
scss
Copy code
Average_Profit = SUM(Profit) / COUNT_DISTINCT([Region])
Replace [Region] with the appropriate dimension for your dataset.
Test in a Table Visualization:
Add a table to your story and include the calculated measure alongside Region.
Check if the calculated measure is showing the correct average for each region.
Refresh Data:
Refresh the model or data source to ensure the calculated measure is updated correctly.
Check for Story-Level Overrides:
Look for any story-level custom aggregations that might be overriding your calculated measure settings.
Thanks in advance
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.