SQL select & group-by as DAX

Question

我正试图从我的数据库中创建一个新的power BI度量值-我有一个表，可以从中运行查询并获得结果的csv文件，但我想设置报告以查看最新数据，csv只是一个快照。我对单个行条目(错误发生次数(进行计数，以创建错误计数，并希望按日期(RTO_PDATED(和位置(RTO_BLOCK(对这些条目进行分组，以分析我们在何时何地遇到这些错误

这是下面的代码：

select count(*) as Errors,
cast(RTO_UPDATED as date) as Date,
RTO_BLOCK
FROM [MIS_Apps].[dbo].[LiveRTOLocationErrorsHistorical]
group by cast(RTO_UPDATED as date),
RTO_BLOCK

如果有人能帮我把它转换成DAX，将不胜感激

我试过这个(下面(，但显然评估语法不正确，我不确定当涉及到groupby时如何更改它？

EVALUATE SELECTCOLUMNS( 
count(*) as Errors, cast(RTO_UPDATED as date) as Date, RTO_BLOCK 
FROM [MIS_Apps].[dbo].[LiveRTOLocationErrorsHistorical] 
group by cast(RTO_UPDATED as date), RTO_BLOCK 
)

Answer 1

在Power BI报告中添加一个自定义表，尝试以下操作。在"自定义表生成"窗口中添加以下代码。

Group_by_result = 
GROUPBY (
// -- This is the table name
LiveRTOLocationErrorsHistorical,
// -- Below two column are GROUP BY columns
LiveRTOLocationErrorsHistorical[RTO_UPDATED],
LiveRTOLocationErrorsHistorical[RTO_BLOCK ],
// -- Here comes the aggregation
"Total_count", COUNTX(CURRENTGROUP(), 1)
)