Forum Discussion
WHERE Syntax Error - Query preparation failed. (Power BI Report Builder)
Hi, In Report Builder this statement works fine using ORDER BY : EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Index],'ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location...
ORDERBY is a valid DAX query keyword whereas WHERE is not (it's a SQL keyword).
use filter or calculatetable to apply filter according to your needs.