Forum Discussion

Swalker's avatar
Swalker
Frequent Visitor
3 years ago

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...
[Help Neede]
[Query Designer]
[Report Builder]
PBI Report Builder
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

R1k91 is correct, there is no WHERE keyword in DAX

But, you can also include filters in the SUMMARIZECOLUMNS see SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Learn

EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Index],'ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector], 'ReferenceList'[Location] = "Europe")