General Information

.NET Subscription

Overview

Common Tools

Project Converter

Assembly Deployment Tool

Localization Service

Desktop

Controls

WinForms

WPF

UWP (Windows 10)

Tools

WinForms Skin Editor

WPF Theme Editor

WPF Theme Designer

Coded UI Test Extension

Web

Controls and Extensions

ASP.NET WebForms Controls

ASP.NET MVC Extensions

ASP.NET Core Controls

ASP.NET Bootstrap Controls

ASP.NET Core Bootstrap Controls

DevExtreme

Tools

ASP.NET Theme Builder

ASP.NET Theme Deployer

Enterprise and Analytic Tools

Reporting

Report and Dashboard Server

Dashboard

Office File API

Code / Debug / Refactor

CodeRush

CodeRush Classic

TestCafe

Logify

Frameworks and Libraries

eXpressApp Framework

eXpress Persistent Objects

XPO Profiler

Core Libraries

IOS, Android & Xamarin

Mobile Charts

Xamarin.Forms Grid

Measure.Calculation Property

Gets or sets a calculation applied to values of the current measure.

Namespace: DevExpress.DashboardCommon

Assembly: DevExpress.Dashboard.v18.2.Core.dll

public MeasureCalculation Calculation { get; set; }

Public Property Calculation As MeasureCalculation

Property Value

Type	Default	Description
MeasureCalculation		A MeasureCalculation descendant that specifies a calculation applied to values of the current measure.

To apply a calculation to values of the required measure, perform the following steps.

Create the MeasureCalculation class instance, initialize its settings and assign the resulting object to the Calculation property. As an alternative, you can specify a calculation by adding the required calculation functions inside the measure expression (Measure.Expression).
Specify a window used to apply a calculation. To do this, create and initialize the required descendant of the MeasureCalculationWindowDefinition class (depending on the type of the target dashboard item) and assign the resulting object to the Measure.WindowDefinition property.

To learn more, see Window Calculations.

Examples

The code snippet below shows how to create the RunningTotalCalculation for the Extended Price measure. The calculation is performed along columns of the Pivot dashboard item.

C#
VB.NET

            // ...
            Measure extendedPrice = new Measure("Extended Price");

            PivotWindowDefinition pivotWindowDefinition = new PivotWindowDefinition();
            pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns; 
            extendedPrice.WindowDefinition = pivotWindowDefinition;

            RunningTotalCalculation runningSum = new RunningTotalCalculation();
            runningSum.SummaryType = SummaryType.Sum;
            extendedPrice.Calculation = runningSum;

            ' ...
            Dim extendedPrice As New Measure("Extended Price")

            Dim pivotWindowDefinition As New PivotWindowDefinition()
            pivotWindowDefinition.DefinitionMode = PivotWindowDefinitionMode.Columns
            extendedPrice.WindowDefinition = pivotWindowDefinition

            Dim runningSum As New RunningTotalCalculation()
            runningSum.SummaryType = SummaryType.Sum
            extendedPrice.Calculation = runningSum