Convert calculated column formula to measure

Hi Anonymous ,

Try this:

Jan =
IF (
    CALCULATE (
        COUNT ( SAP_Data[Period] ),
        FILTER ( SAP_Data, SAP_Data[Period] = 1 )
    ) = 0,
    0,
    IF (
        MAX ( CON_9[Country] ) = "Germany",
        CALCULATE (
            SUM ( SAP_Data[O_AMT] ),
            FILTER (
                SAP_Data,
                SAP_Data[Month] = "Jan"
                    && SAP_Data[Country] = MAX ( CON_9[Country] )
                    && SAP_Data[Item_Code] = MAX ( CON_9[Item_code] )
            )
        )
            - CALCULATE (
                SUM ( CON_8[Jan] ),
                FILTER ( CON_8, CON_8[Country] = MAX ( CON_9[Country] ) )
            )
            + CALCULATE (
                SUM ( TAX[T_AMT] ),
                FILTER (
                    TAX,
                    TAX[Month] = "Jan"
                        && TAX[Country] = MAX ( CON_9[Country] )
                        && TAX[Item_Code] = MAX ( CON_9[Item_code] )
                )
            ),
        IF (
            MAX ( CON_9[Country] ) = "Italy",
            CALCULATE (
                SUM ( SAP_Data[O_AMT] ),
                FILTER (
                    SAP_Data,
                    SAP_Data[Month] = "Jan"
                        && SAP_Data[Country] = MAX ( CON_9[Country] )
                        && SAP_Data[Item_Code] = MAX ( CON_9[Item_code] )
                )
            )
                - CALCULATE (
                    SUM ( CON_8[Jan] ),
                    FILTER ( CON_8, CON_8[Country] = MAX ( CON_9[Country] ) )
                )
                + CALCULATE (
                    SUM ( TAX[T_AMT] ),
                    FILTER (
                        TAX,
                        TAX[Month] = "Jan"
                            && TAX[Country] = MAX ( CON_9[Country] )
                            && TAX[Item_Code] = MAX ( CON_9[Item_code] )
                    )
                ),
            0
        )
    )
)

If there are some errors, please give me some screenshots or data sample.

Best Regards,
Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.