powerbi - Power BI 计算

Question

我正在尝试创建一个将从下表中计算值的度量。如何计算至少有一项任务和日期的项目以及如何计算有两个任务和日期的项目？

额外问题：我如何计算至少有一项任务但没有日期（空）的项目，我如何计算完成两项任务但没有日期的项目？

标签： powerbidax

Answer 1

以下4个措施适合您-

1.

one_one = 

var count_task_1 = IF(min(project_count[task 1]) <> BLANK() && MIN(project_count[date 1]) <> BLANK(),1,0)
var count_task_2 = IF(min(project_count[task 2]) <> BLANK() && MIN(project_count[date 2]) <> BLANK(),1,0)
var count_task_3 = IF(min(project_count[task 3]) <> BLANK() && MIN(project_count[date 3]) <> BLANK(),1,0)

RETURN
IF(
    (count_task_1+count_task_2+count_task_3) >= 1,
    1,
    0
)

2.

two_two = 

var count_task_1 = IF(min(project_count[task 1]) <> BLANK() && MIN(project_count[date 1]) <> BLANK(),1,0)
var count_task_2 = IF(min(project_count[task 2]) <> BLANK() && MIN(project_count[date 2]) <> BLANK(),1,0)
var count_task_3 = IF(min(project_count[task 3]) <> BLANK() && MIN(project_count[date 3]) <> BLANK(),1,0)

RETURN
IF(
    (count_task_1+count_task_2+count_task_3) >= 2,
    1,
    0
)

3.

one_no_date = 

var count_task_1 = IF(min(project_count[task 1]) <> BLANK() && MIN(project_count[date 1]) = BLANK(),1,0)
var count_task_2 = IF(min(project_count[task 2]) <> BLANK() && MIN(project_count[date 2]) = BLANK(),1,0)
var count_task_3 = IF(min(project_count[task 3]) <> BLANK() && MIN(project_count[date 3]) = BLANK(),1,0)

RETURN
IF(
    (count_task_1+count_task_2+count_task_3) >= 1,
    1,
    0
)

4.

two_no_date = 

var count_task_1 = IF(min(project_count[task 1]) <> BLANK() && MIN(project_count[date 1]) = BLANK(),1,0)
var count_task_2 = IF(min(project_count[task 2]) <> BLANK() && MIN(project_count[date 2]) = BLANK(),1,0)
var count_task_3 = IF(min(project_count[task 3]) <> BLANK() && MIN(project_count[date 3]) = BLANK(),1,0)

RETURN
IF(
    (count_task_1+count_task_2+count_task_3) >= 2,
    1,
    0
)

这是输出 -

您可以使用这些逻辑进行其他必要的计算