function - PowerBI - 根据多列中的值计算行数

Question

PowerBi Desktop v 2.64.5285.741 64 位(2018 年 11 月)

你好，

假设我有一个名为 WorkReport

的表

在 PowerBi Desktop 中，查找包含 Status = 'Not Started' 和 Progress = "slow" 的行数的正确 DAX 语法是什么？

下面我将提供我尝试失败的查询列表:

report = CALCULATE(COUNTAX(WorkReport,WorkReport[Status]),
WorkReport[Status] = "未开始") &&
WorkReport[进度]WorkReport[进度], WorkReport[进度] =
“慢”)

report = CALCULATE(COUNT(WorkReport,WorkReport[Status]),
WorkReport[Status] = "未开始") &&
WorkReport[进度]WorkReport[进度], WorkReport[进度] =
“慢”)

report = CALCULATE(COUNTAX(WorkReport,WorkReport[Status]),
工作报告[状态] =“未开始”)和
WorkReport[进度]WorkReport[进度], WorkReport[进度] =
“慢”)

report = CALCULATE(COUNT(WorkReport,WorkReport[Status]),
工作报告[状态] =“未开始”)和
WorkReport[进度]WorkReport[进度], WorkReport[进度] =
“慢”)

report = COUNTROWS(FILTER(WorkReport,WorkReport[Status]="NotStarted")
AND (WorkReport, WorkReport[progress] = "slow"))

report = COUNTROWS(FILTER(WorkReport,WorkReport[Status]="NotStarted")
&& (WorkReport, WorkReport[progress] = "slow"))

请告知您是否能够在 PowerBI 桌面工具中实现此目的。谢谢!

Answer 1

度量本身是一个简单的COUNTROWS，但您需要使用CALCULATE 来转换上下文，应用您想要的过滤器:

MyMeasure = 
    CALCULATE ( 
        COUNTROWS ( WorkReport ),
        WorkReport[Status] = "Not Started",
        WorkReport[Progress] = "slow"
    )