Querry preparation failed

[filipkaczmarczy]

Hi all,

I am learning DAX and I have got a problem with Querry typed below:

EVALUATE
SUMMARIZECOLUMNS(
'Pick DC'[PDC Country],
'Pick DC'[PDC Number],
'Material'[MAT Business ID],
Customer[CS Customer Number],
Customer[CS Customer Description],
Material[MAT WRIN0],
Material[MAT Description],
Picking[Sales Order Key],
'Pick Date'[PD Date],
KEEPFILTERS( TREATAS( {"MCD","VAP","VGS","KFC"}, Material[MAT Business ID] )),
Filter('Pick Date','Pick Date'[PD Date]>=Today()),
Filter('Picking','Picking'[PCK Pick Order Status]=321),
Filter(VALUES(Material[MAT Business ID]),PATHCONTAINS(@MaterialMATBusinessID,Material[MAT Business ID])),
"Picked Planned Quantity",[Sales Order To Be Picked Quantity]
)

I am getting an error: Querry preparation failed

Do you know why this is happening? I am working on Power BI Report Builder

Thank you for help 🙂 

[Anonymous]

Hi @filipkaczmarczy ,

As checked the formula which you provided, it seems OK. I found a thread which has the similar problem as yours, please check if its solution can help you resolve the problem.

DAX Query fails to prepare

I copy pasted everything (queries + tablix) in a new blank report and that works. Maybe I switched a setting somewhere or the file was corrupted. I have no idea.

Anyway, now that works.

---

Best Regards

[amitchandak]

@filipkaczmarczy , Syntax looks correct , the way to check is, Run this on Dax studio

Start with one or two items and keep on adding after every successful, that should give you error