SQL,DAX的比较

以下SQL和DAX一样：

1，

SQL

SELECT *FROM Product

 

DAX

EVALUATE Product

2，

SQL

SELECT [Product Id], [Product Name], [List Price]FROM Product

 

DAX

EVALUATEADDCOLUMNS(    DISTINCT( Product[Product Id] ),    "Product Name", CALCULATE( VALUES( Product[Product Name] ) ),    "List Price", CALCULATE( VALUES( Product[List Price] ) ))

 

DAX

34567 

EVALUATESUMMARIZE(    Product,    Product[Product Id],    Product[Product Name],    Product[List Price]) 

 

也许更准确地，上面SUMMARIZE相当于SQL的SELECT DISTINCT 语句，既：

SQL

SELECT DISTINCT [Product Id], [Product Name], [List Price]FROM Product