<div>
Don't know DAX but from a quick Google into ALLEXCEPT I'm not sure we have all the information for a direct port to SQL.<br />
<br />
The docs mention that ALLEXCEPT applies a 'filter' if one exists. &nbsp;That would likely be a CASE statement or a WHERE clause in SQL.<br />
<br />
If you can provide some raw data and expected results from the provided data, we can provide the SQL to achieve the results.<br />
<br />
Database product and version would help a lot as well.
</div>


Don't know DAX but from a quick Google into ALLEXCEPT I'm not sure we have all the information for a direct port to SQL.

The docs mention that ALLEXCEPT applies a 'filter' if one exists.  That would likely be a CASE statement or a WHERE clause in SQL.

If you can provide some raw data and expected results from the provided data, we can provide the SQL to achieve the results.

Database product and version would help a lot as well.

Junior

route217

<div>
<div class="content wysiwyg-content fr-view">
Hi Experts<br><br>What is the SQL equivalent of the following DAX (Power BI) Formula<br>AOV = CALCULATE(SUM(FACTSalesOrderTable[Gross_Order_Value]),ALLEXCEPT(FACTSalesOrderTable,FACTSalesOrderTable[increment_id]))<br><br><br>
</div>
</div>



Hi Experts
What is the SQL equivalent of the following DAX (Power BI) Formula
AOV = CALCULATE(SUM(FACTSalesOrderTable[Gross_Order_Value]),ALLEXCEPT(FACTSalesOrderTable,FACTSalesOrderTable[increment_id]))

Convert a Power Formula into SQL Syntex

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Power BI

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.