Forum Discussion
cell magic %%dax returning error
Hi mark_carlisle ,
It looks like there is some syntax issue - while working with FILTER and KEEPFILTERS.
Try to refer this Link - Using KEEPFILTERS in DAX - SQLBI inorder to debug your syntax issue.
Additional References -
Solved: 1. Diff between Filter() and KeepFilters() - Microsoft Fabric Community
Hope this is helpful. Please let me know incase of further queries.
The DAX runs without issue in DAX Studio so unless you can highlight the specific syntax issue then I'm not confident your reply is correct.
I think the more likely issue is that theres some issue with how its been implemented in the fabric.evaluate_dax() function.
- Anonymous2 years agoNot applicable
Hi mark_carlisle ,
Apologies for the issue you have been facing. As you were able to execute DAX query without any issue, this might be problem with fabric.evaluate_dax() function.
This might require a deeper investigation from our engineering team and they can guide you better.
Please go ahead and raise a support ticket to reach our support team:
https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.
Hope this is helpful. Please let me know incase of further queries.- Anonymous2 years agoNot applicable
Hello mark_carlisle ,
We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket. If yes, please provide the ticket number here as we can keep an eye on it.