Error in Calculation Group Format String Expression in Composite Model

[acecinati]

Hi everyone!

I've a composite model with local calculation group.

I've noted that if I specify Format String Expression in the Calculation Items all the remote measures break down with the following error:"It is not possible to determine a value for the <measurename> FormatString". Even if I don't use that calculation group.

Here a video to explain it better.

https://youtu.be/BLnUZeqMdo4

Thanks in advance,

Angelo

[v-yetao1-msft]

Hi @acecinati 

If you didn't specify Format String Expression in the Calculation Items , the measure can display in visual normally , right ?

Best Regards,
Community Support Team _ Ailsa Tao

[acecinati]

@v-yetao1-msft Yes, exactly.

Removing that string I can use the measure in every context.

While inserting the format string the measure works only in the calculation group context.

Using the calculation group format string is useful in order to mantain the orginal numerical data type.

I could use the DAX FORMAT function, but the number would be tranformed in text when exported.

Thanks,

Angelo