I’m having serious troubles working with DAX there are several functions that aren’t working properly, I send you 4 different calculations with the same fields (the fields are in the same table) that...
I’ve got response from the Product Team.
There is an issue due to a limitation in the level of SQL support on Oracle 11. This means that there are issues with the form of SQL generated by Power BI, when using calculated columns, or measures with scalar expressions. In many cases (at least for calculated columns, or measures like SUMX(Sales, Price*Qty) , it is possible to define such expressions as part of the query in the Query Editor, as a workaround. We will look to generate a different form of SQL when using Oracle 11 to avoid such issues.
Best Regards,
Herbert