你可以通过下面的dax计算表来实现这一点

Table = summarize(example_table[z], "sumcount", sum(example_table[x]), " Avgcount", Average(example_table[Y]))

你可以从直接查询功能中执行sql查询，其中连接数据主机和模式。

如何在Power BI中创建从SQL到DAX的代码：

Select
   History.[Key],
   History.[Issue Type],
   History.[Current Status],
   SUM(History.[Time in Old Value (business days)]) as 'Blocked Time'
FROM History
INNER JOIN CYCLOTIME
   ON HISTORY.[KEY] = CYCLOTIME.[KEY]
   AND HISTORY.[History Start] >= CycloTime.[Dt Inicio]
Where 
   History[History Field] = "flagged"
and
   History[History Old Value] = "Impedimento"
GROUP BY
   History.[Key],
   History.[Issue Type],
   History.[Current Status]