Forum Discussion
'FILTER' syntax is suddenly incorrect
Hi all, I've been working with this particular report for quite some time. I created it ages ago and it has been reloading on a daily basis and people in my company are using it quite often. But ...
- I was using another PC that had different settings, which messed up the distinction between ',' and ';'. My bad!
Yeah, I know how TOPN works in a situation like that. 😉
v-xuding-msft
Community Support
Community SupportHi Anonymous ,
For the function of FILTER, it returns a table that represents a subset of another table or expression. It can be used alone to create a calculated table. So you get the error message: 'The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value' in a measure.
But for the error: 'FILTER' syntax is incorrect, I'm not clear. I have checked your formula. And I think it should work. Please share more details, like the sample data, expected output and a few screenshots of that error. If you can share a dummy pbix file, it is more helpful for us to understand your situation.