Forum Discussion

ajit_singh's avatar
ajit_singh
Frequent Visitor
5 years ago
Solved

Using calculation group to selectively replace measures "as well as replace measure format"

Using calculation group, measures can be selectively replaced in a placeholder measure as explained in the article: https://www.sqlbi.com/articles/using-calculation-groups-to-selectively-replace-mea...
  • ajit_singh's avatar
    ajit_singh
    5 years ago

    I think the requirement can not be implemented.

    The reason being "Format String Expressions" option is not available to regular measures, only available to calculation items.

    Here [Margin %] being a regular measure, only static "format string" can be applied, not dynamically based on the calculation item selection using "Format String Expressions".

    It would be a good feature addition, being able to apply dynamic formatting to regular measures using "Format String Expressions".

     

ajit_singh's avatar
ajit_singh
Frequent Visitor
5 years ago

I think the requirement can not be implemented.

The reason being "Format String Expressions" option is not available to regular measures, only available to calculation items.

Here [Margin %] being a regular measure, only static "format string" can be applied, not dynamically based on the calculation item selection using "Format String Expressions".

It would be a good feature addition, being able to apply dynamic formatting to regular measures using "Format String Expressions".