以下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