DirectQuery to SAP BW - filter on measure

[FilipVDR]

Hello,

In this table i want to filter out the records with "Meting 37" "0".

"Belangrijke getallen 37" is a measure which is calculated in SAP 

We tried to create a DAX formula but it keeps running, probably because it's direct query and there is an issue?

Meting 37 = IF( 'Belangrijke getallen'[37]=0, BLANK(), 'Belangrijke getallen'[37])

It's not an option to filter on "Belangrijke getallen 37" as it's not possible to enter something.

[FilipVDR]

How can I look at a folded query if it's direct query? 

[lbendlin]

You can see the folded query in the performance analyzer ("Copy Query") and then either Dax Query view or DAX Studio.

[lbendlin]

"Belangrijke getallen 37" is a measure which is calculated in SAP 

then to you it should look like just another column. 

Have you looked at the folded query?