Forum Discussion

tenfingers's avatar
tenfingers
Icon for Advocate II rankAdvocate II
6 years ago

Creating a calculation group in Tabular Editor disables the format dropdown in Measure Tools

When I create a simple calculation group in Tabular Editor, it greys out / disables the format dropdown in the formatting area of Measure Tools in Report and table view. I am still able to change for...
General Comment
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, tenfingers 

 

I wonder if the measure uses FORMAT  function to converts a value to text according to the specified format. All predefined formatting strings use the current user locale when formatting the result. The format strings supported as an argument to the DAX FORMAT function are based on the format strings used by Visual Basic (OLE Automation), not on the format strings used by the .NET Framework. Therefore, you might get unexpected results or an error if the argument doesn't match any defined format strings.

 

Best Regards

Allan

 

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

tenfingers's avatar
tenfingers
Icon for Advocate II rankAdvocate II
6 years ago

Hi v-alq-msft ,

 

Thanks for your reply, this actually affects all measures in my models. After creating a calculation group of any type, even with just a single basic SUM measure as a calculation item, the format option becomes disabled for all measures in the model. I have the measures in a measured table, I'm wondering if that has anything to do with it. In any case, I don't think any of the measures in the models use the DAX FORMAT function. 
Cheers

  • tenfingers's avatar
    tenfingers
    Icon for Advocate II rankAdvocate II
    6 years ago

    * measures table