Dynamic Format String Expression error

[Tomi]

Couldn't load the data for this visual
CalculationProperty(measure xxx) (1,1) Calculation error in measure xxx/
Invalid FormatStringDefinition expression of measure xxx. FormatStringDefinition must have a DAX expression which is of type String.

-----------------
Measure xxx uses a dynamic format string expression by referencing [MeasureABC] which returns type string.  A simplified expression is shown below.

--------------------
[MeasureABC] = "#,0"

--------------------
Note - issue only occurs after a new unrelated and unused calculation group was added to the model. Workaround fix - can be resolved by a) simply deleting the calculation group or b) by simply copying the "#,0" directly into the measure xxx formatstringexpression and for all other measures instead of referencing [MeasureABC]. Why is the existence of a calc group cause this error to happen when it works fine before? This issue can be re-produced.

[FGutier2963]

Did you ever find a solution to this? I'm encountering the same issue and no support online for it.

[Anonymous]

Hi @Tomi ,

Based on the knowledge, dynamic format strings can be used with calculation groups.

You can view the following document to learn more about how to create a dynamic format string.

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.