my measure is giving wrong total value in table visual

[Shrujan1612]

CS Mix measure is giving total as zero in table, so i have created CS Mix Summ for total value but that is giving wrong total and row level values as zero, can anyone help me with this issue?

CS Mix =

VAR Curr_month =

        CALCULATE (

            [CS Cont] ,

            DATESBETWEEN (

                'Calendar'[Calendar date],

                [PeriodStart],

                [PeriodEnd]

            )

        )

VAR Pre_month =

        CALCULATE (

            [CS Cont],

            DATESBETWEEN ( 'Calendar'[Calendar date], [PriorPeriodStart], [PriorPeriodEnd] )

        )

VAR Pre_month_CS =

    CALCULATE (

        [Value per CS],

        DATESBETWEEN (

            'Calendar'[Calendar date],

            [PriorPeriodStart],

            [PriorPeriodEnd]

        )

    )

VAR Total_Pre_month_CS =

    CALCULATE (

        [Value per CS],

        ALLSELECTED (),

        DATESBETWEEN ( 'Calendar'[Calendar date], [PriorPeriodStart], [PriorPeriodEnd] )

    )

VAR Total_Curr_stock =

    CALCULATE (

        [Total Stock],

        ALLSELECTED (),

        DATESBETWEEN ( 'Calendar'[Calendar date], [PeriodStart], [PeriodEnd] )

    )

VAR Total =

    IF (

        ISBLANK ( ( Curr_month - Pre_month ) * Total_Curr_stock * ( Pre_month_CS - Total_Pre_month_CS ) ),

        0,

        ( Curr_month - Pre_month ) * Total_Curr_stock * ( Pre_month_CS - Total_Pre_month_CS )

    )

RETURN Total

CS Mix Summ =

 VAR A2 = ADDCOLUMNS(

                    SUMMARIZE('Inventory Balance','Inventory Balance'[PlantID],'Inventory Balance'[ProductId]),

                       "CSMixImpact", CALCULATE([CS Mix] ))

Return SUMX(A2, [CSMixImpact])

CS MIX Impact = [CS Mix] + [CS Mix Summ]

Thanks in advance

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...