Page Comparison

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 format that can be applied to a worksheet or Dashboard. When the value of a dimension filter is changed, the measure format of the calculated measures will automatically update to reflect the selected value of the dimension filter. See the Filtering data in worksheets section for more details. 

...

• Calculated measure: Displays the Measure value when the filter value is changed. 

• Format measure: Displays the Measure format along with the Measure value. You can also reuse the Measure format 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 format of the calculated measure will change accordingly.

Consider an example where a Calculated Measure displays a dynamic format, i.e., DYNAMIC_FORMAT = [Measures].[FormatMeasure]

• Following is the sample expression for a calculated measure

  Code Block

  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_FORMAT = [Measures].[FormatMeasure]

• Following is the sample expression for a format measure

  Code Block
  iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YOY], "$#,##0.00", iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[YTD], "0.00% ", iif([CalculationType].[CalculationType].currentmember is [CalculationType].[CalculationType].&[MTD], "#,##0.000000" , “#,##0.00”)))

...

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.

Aura tab collection
params JTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJ3aWR0aCUyMiUzQTElMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyM2NjY2VjZiUyMiU3RCU3RCU3RCU3RA==
Aura tab summary Tab 1 Expression for Calculated Measure params JTdCJTIydGl0bGUlMjIlM0ElMjJUYWIlMjAxJTIwJTIyJTdE These are the steps Step 1 for editing Step 2 for editing JTdCJTIydGl0bGUlMjIlM0ElMjJFeHByZXNzaW9uJTIwZm9yJTIwQ2FsY3VsYXRlZCUyME1lYXN1cmUlMjIlN0Q= Image Added Aura tab summary Tab 2 Expression for Dynamic Format params JTdCJTIydGl0bGUlMjIlM0ElMjJUYWIlMjAyJTIwJTIyJTdE Step 1 for editing Step 2 for editing JTdCJTIydGl0bGUlMjIlM0ElMjJFeHByZXNzaW9uJTIwZm9yJTIwRHluYW1pYyUyMEZvcm1hdCUyMiU3RA== Image Added

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

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

   

   Dynamic Format Measure- Worksheet 

   

   Dynamic Format Measure- Dashboard