将此 Tableau 计算转换为 DAX PBI 度量值

问：

我有这个Tableau计算：

if [wlb_metric_name]='Count at Shift End'
and date([Interval_end_Datetime_ET]) = [Shift End Time]
and date([Shift Start Datetime])= [Overnight Shift Start Date]
and [Date] = Date([Interval_Start_Datetime_ET])
and [Date] = [Shift End Time]
then [wlb_metric_value] else 0 end
)/
COUNT(
if [wlb_metric_name]='Count at Shift End'
and date([Interval_end_Datetime_ET]) = [Shift End Time]
and date([Shift Start Datetime])= [Overnight Shift Start Date]
and [Date] = Date([Interval_Start_Datetime_ET])
and [Date] = [Shift End Time]
then [wlb_metric_value] else null end
),0) 

我需要将其转换为 PBI Dax Measure。这是我尝试过的代码，但显然它是不正确的

IF(
    ISBLANK(SUMX(
        FILTER(
            'Workload Balancing Fact',
            [wlb_metric_name] = "Count at Shift End"
                && [Interval_end_Datetime_ET].[Date] = [Shift End Time]
                && [Shift Start Datetime].[Date] = [Overnight Shift Start Date]
                && [Date] = [Interval_Start_Datetime_ET].[Date]
                && [Date] = [Overnight Shift Start Date].[Date]
        ),
        [wlb_metric_value]
    ) / COUNTX(
        FILTER(
            'Workload Balancing Fact',
            [wlb_metric_name] = "Count at Shift End"
                && [Interval_end_Datetime_ET].[Date] = [Shift End Time]
                && [Shift Start Datetime].[Date] = [Overnight Shift Start Date]
                && [Date] = [Interval_Start_Datetime_ET].[Date]
                && [Date] = [Overnight Shift Start Date]
        ),
        [wlb_metric_value]
    )),
    0,
    SUMX(
        FILTER(
            'Workload Balancing Fact',
            [wlb_metric_name] = "Count at Shift End"
                && [Interval_end_Datetime_ET].[Date] = [Shift End Time]
                && [Shift Start Datetime].[Date] = [Overnight Shift Start Date]
                && [Date] = [Interval_Start_Datetime_ET].[Date]
                && [Date] = [Overnight Shift Start Date]
        ),
        [wlb_metric_value]
    ) / COUNTX(
        FILTER(
            'Workload Balancing Fact',
            [wlb_metric_name] = "Count at Shift End"
                && [Interval_end_Datetime_ET].[Date] = [Shift End Time]
                && [Shift Start Datetime].[Date] = [Overnight Shift Start Date]
                && [Date] = [Interval_Start_Datetime_ET].[Date]
                && [Date] = [Shift End Time]
        ),
        [wlb_metric_value]
    )
)

我一直在绞尽脑汁地想我在哪里做错了这个计算。我没有收到错误，这在技术上更糟。请帮忙！