DAX measure get syntax error when save file

Hi carrot6981 

I'm assuming under your Windows regional settings that the decimal separator and list separator are both "," (comma). Is that correct?

It appears that Power BI Desktop can get confused when a comma is "ambiguous", in that it can be interpreted as either a decimal or a list separator, in this case the comma following the 1. It appears to interpret the comma as a list separator when the expression is first entered, then re-interpret it as a decimal separator when saving (and convert it to ".").

I was able to replicate your issue with these steps:

1. Sett my Windows decimal separator and list separator to comma in Control Panel > Region > Additional Settings
2. Open Power BI Desktop and check that Options > Global > Regional Settings > DAX Separators is set to "Use localized DAX separators".
3. Close Power BI Desktop
4. Open your PBIX
5. Save your PBIX

Recommended solution:

1. I recommend changing the Power BI Desktop DAX separators setting in screenshot above to "Use standard DAX separators" to avoid this whole issue (restart after changing this setting).

This would require you to use "." as decimal separator and "," as list separator in all DAX expressions.

2. Alternatively, you could leave this setting unchanged and remove ambiguity by inserting white space between any numbers followed by list separators.

e.g. Change this

1,

to this

1 ,​

This would be a bit awkward in practice, so I recommend the first solution.

Does this help at your end?