QlikView Expression to Dax Expression

[sagrawa]

sum({<
    Apportionment_Category={
        'Fixed Assets',
        'Inventory/CIP',
        'Land'
    },
    Year_End_Flag = {'2'}
>}Amount)
+sum({<
    Apportionment_Category={
        'Depreciation',
        'Gains/Losses',
        'Other Income',
        'Payroll',
        'Rent/Leases',
        'Sales'
    },
    Year_End_Flag = {'0'}
>}Amount)
 

[sagrawa]

Thanks for Reply

[TomasAndersson]

SUMX(
    FILTER(
        'Table',
        'Table'[Apportionment_Category] IN {
            "Fixed Assets",
            "Inventory/CIP",
            "Land"
        }
        && 'Table'[Year_End_Flag] = "2"
    ),
    'Table'[Amount]
)
+ SUMX(
    FILTER(
        'Table',
        'Table'[Apportionment_Category] IN {
            "Depreciation",
            "Gains/Losses",
            "Other Income",
            "Payroll",
            "Rent/Leases",
            "Sales"
        }
        && 'Table'[Year_End_Flag] = "0"
    ),
    'Table'[Amount]
)

[sagrawa]

Thanks