DAX -如何在GROUPBY中对列使用条件

Question

我有一项措施：

VAR calcTable = CALCULATETABLE(
GROUPBY(
'Certification History';
'Certification History'[ID Entity-account];
"Rejections"; SUMX(CURRENTGROUP(); 1)
);
FILTER(
ALLEXCEPT('Certification History'; 'Certification History'[ID Entity-account]; 'Certification History'[Report Date]);
'Certification History'[Status] = "Rejected"
)
)
RETURN
IF(
ISFILTERED('Certification History'[ID Entity-account]);
SUMX(calcTable; [Rejections]);
COUNTROWS(calcTable)
)

我需要它返回“calcTable”‘Rejections >= {some }的和或计数。

Answer 1

如果要在计算表上应用筛选器，则可以在表上使用筛选器函数：

VAR calcTable = 
CALCULATETABLE(GROUPBY('Certification History';
                        'Certification History'[ID Entity-account];
                        "Rejections"; SUMX(CURRENTGROUP(); 1)
                        );
                FILTER(ALLEXCEPT('Certification History'; 'Certification History'[ID Entity-account]; 
                                                          'Certification History'[Report Date]);
                                'Certification History'[Status] = "Rejected"
                    ) 
            )
RETURN IF(ISFILTERED('Certification History'[ID Entity-account]);
          SUMX(FILTER(calcTable;[Rejections]>= {some value}); [Rejections]);
          COUNTROWS(FILTER(calcTable;[Rejections]>= {some value})
          )

希望这能有所帮助。