Document toolboxDocument toolbox

Adding a Dynamic Measure Title

Owned by Sarabjeet Kaur
Jul 17, 2024
3 min read

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos supports a Dynamic Measure title that can be applied to a worksheet or Dashboard. When the value of a dimension filter is changed, the measure title will automatically update to reflect the selected value of the dimension filter. See the Filtering data in worksheets section for more details. 

To make the Dynamic Measure title work, you need to create the expressions for the following:

  • Measure value: Displays the M easure value when the filter value is changed. 

  • Measure title: Displays the Measure title along with the Measure value. You can also reuse the Measure title for other Measure values.

Sample Expression

For example, you have a semantic model with a dimension called 'Calculation Type,' and this dimension has members such as MTD, YOY, YTD, and so on. Multiple calculated measures are created in the semantic model, and their values depend on the Calculation Type filter selected in the view. When you modify the filter value, the title of the measure will change accordingly.

Consider an example where a Calculated Measure displays a dynamic title, i.e., 'Dynamic Caption'.

  • Following is the sample expression for a dynamic Measure value

    iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY], "YOY ", iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD], "YTD ", iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD], "MTD " ,null)))

  • Following is the sample expression for a dynamic Measure title

    iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY], [Measures].[YOY Sales], iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD], [Measures].[YTD Sales], iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD], [Measures].[MTD Sales],null))), DYNAMIC_CAPTION = [Measures].[Dynamic Caption] + "On Sales"

If the filter is set to 'YOY' and the 'Sales Cal' Measure is visible in the View, the Measure title will be 'YOY on Sales'. This title combines the strings of the 'Sales Cal' Measure and the Dynamic Caption measure, as shown below:

  • Filter: Calculation Type = YOY

  • Measures: Sales Cal

  • Measure Title: YOY on Sales

Note

  • The changes are specific to the Kyvos Visualization layer and will not impact any third-party BI tool.

  • When the filter is not applied to the Calculation Type Hierarchy or is applied to multiple members of the hierarchy, the Measure Name (also referred to as the static caption), as displayed in the above example (such as 'On Sales'), will be shown. However, if the filter is applied to a single member of the Calculation Type Hierarchy, the Measure value you have set by using the DYNAMIC_CAPTION function will be displayed on the KPIs,  charts, labels, titles, axes, tooltips, and legends.

  • Kyvos supports naming semantic model entities in the  ENTITY_  format, such as  DIMENSION_,  DIM_, MEASURE_, and so on.

To add a Dynamic Measure value and title, perform the following steps. 

  1. In the Measures column, select the measure. 

  2. In  Measure Properties, select Expression.

  3. On the  Expression  dialog box, specify the expression as per your requirement. Click the i icons to learn more.

  1. Click Validate to validate your criteria. 
    If you have made changes and don’t want to keep them, click Cancel.

  2. Click Save. The Dynamic Measure name and caption that you created are applicable to a Worksheet or a Dashboard.  
    Worksheet 


    Dashboard 

Copyright Kyvos, Inc. All rights reserved.