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”)))
...
Click Validate to validate your criteria.
If you have made changes and don’t want to keep them, click Cancel.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