Intellisense underlines with red ALLSELECTED with multiple columns in a variable, even though the code is valid:
Note that it's not an issue with no variables:
As far as I’m concerned, the table remove filters function like ALL() or ALLSELECTED() is always used with the query function like Calculate(), so that we usually suggest you to write the DAX formula like the method2.
For more info:
Community Support Team _Robert Qin
I noticed it with DISTINCTNOBLANK(<ColumnName>😞 the formula doesn't raise any error, but Intellisense underlines it with a red line.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.