Forum Discussion
DirectQuery to SAP BW - filter on measure
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.
3 Replies
"Belangrijke getallen 37" is a measure which is calculated in SAPthen to you it should look like just another column.
Have you looked at the folded query?
How can I look at a folded query if it's direct query?
You can see the folded query in the performance analyzer ("Copy Query") and then either Dax Query view or DAX Studio.
