The following syntax error occurred during parsing: Invalid token, Line 5, Offset 46,.

[h11]

I'm getting an error on my power Bi when I'm trying to type a measure. The error is "The following syntax error occurred during parsing: Invalid token, Line 5, Offset 46,. Please help.

Thank you!

[halfglassdarkly]

Very hard to read your screenshot at that resolution.

[h11]

@Slim- Measure = VAR _SelectedValue = SELECTEDVALUE('Table 2'[Name])

VAR _Filtered = CALCULATE(DISTINCTCOUNT('Table'[Name]),FILTER('Table','Table'[Status] IN {"Approved", "In Progress"} && 'Table'[Name]=_SelectedValue))

VAR _All = CALCULATE(DISTINCTCOUNT('Table'[Name]))

RETURN

IF(ISBLANK (_SelectedValue), _All, _Filtered)

[Slim- · Accepted solution]

@h11Offset 46 is the end of your last line, I even think that you have only 45 caracters in line 5 so I tried creating two tables with same columns as you and pasting your measure : I did not have any error.

Are you sure that you do not have a caracter hidden at the end of your line 5 or a sixth line below ?

[Slim-]

Hi @h11,

I cannot read the measure in the picture because of the quality,

Can you please paste your measure ?

Regards,