cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Error in Calculation Group Format String Expression in Composite Model

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

Status: Needs Info

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

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

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
Frequent Visitor

@v-yetao1-msft Yes, exactly.

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

acecinati_1-1674807533900.png

 

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

acecinati_0-1674807487700.png

 

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