Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Comments
Anonymous
Not applicable

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
Advocate I

@Anonymous 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