Wrong total

[New_be]

Hi,

I wanted to have totals of 7900 instead of 9061 for measure 'Passes output test'. But instead I got 9061. Can you please help? Below is my measure:

Passes output test =

VAR NormalPassValue =

    CALCULATE(

        SUM('SURFACE TREATMENT MOVEMENTS'[VALUE]),

        FILTER(

            'SURFACE TREATMENT MOVEMENTS',

            'SURFACE TREATMENT MOVEMENTS'[Num. Re-ST] = "Normal pass" &&

            'SURFACE TREATMENT MOVEMENTS'[Actual ST Only] = "TRUE"

        )

    )

VAR Rerun1xValue =

    CALCULATE(

        SUM('SURFACE TREATMENT MOVEMENTS'[VALUE]),

        'SURFACE TREATMENT MOVEMENTS'[Num. Re-ST] = "Re-ST 1x" && 'SURFACE TREATMENT MOVEMENTS'[Actual ST Only] = "TRUE",

        ALLEXCEPT('SURFACE TREATMENT MOVEMENTS', 'SURFACE TREATMENT MOVEMENTS'[Num. Re-ST], 'SURFACE TREATMENT MOVEMENTS'[PRD_ORDERID], 'SURFACE TREATMENT MOVEMENTS'[UNIT], 'SURFACE TREATMENT MOVEMENTS'[Actual ST Only])

    )

VAR AllPassesValue =

    CALCULATE(

        SUM('SURFACE TREATMENT MOVEMENTS'[VALUE]),

        FILTER(

            'SURFACE TREATMENT MOVEMENTS',

            'SURFACE TREATMENT MOVEMENTS'[Actual ST Only] = "TRUE"

        )

    )

VAR __Switch =

    SWITCH(

        TRUE(),

        SELECTEDVALUE('SURFACE TREATMENT MOVEMENTS'[Num. Re-ST]) = "Normal pass", NormalPassValue - Rerun1xValue,

        [Passes output]

    )

VAR Result = IF(AllPassesValue = BLANK(), BLANK(), __Switch)

RETURN Result


Here is my table:

YearWeek

PROCESS

MACHINE

PRD_ORDERID

Actual ST Only

Num. Re-ST

GRADING

UNIT

VALUE

Total Normal Pass

Rerun 1x

Passes output

Passes output test

Y24W34

ST1

ST1

7725354

FALSE

Normal pass

C

SQFT

5372.98

1161

Y24W34

ST1

ST1

7725354

TRUE

Normal pass

C Hitam Sap

SQFT

7225.92

7226

1161

7225.92

6065.1

Y24W34

ST1

ST1

7725354

FALSE

Normal pass

C Sap

SQFT

1178.05

1161

Y24W34

ST1

ST1

7725354

TRUE

Re-ST 1x

C Hitam Sap

SQFT

1160.82

1161

1160.82

1160.82

Y24W34

ST1

ST1

7725354

TRUE

Re-ST 2x

C Hitam Sap

SQFT

674.91

1161

674.91

674.91

9061.65

9061.65

7900.83

[v-kaiyue-msft · Accepted solution]

Hi @New_be ,

You can try this measure.

Correct total = 
IF (
    ISINSCOPE ( 'SURFACE TREATMENT MOVEMENTS'[YearWeek] ),
    [Passes output test],
    SUMX (
        ALLEXCEPT (
            'SURFACE TREATMENT MOVEMENTS',
            'SURFACE TREATMENT MOVEMENTS'[YearWeek]
        ),
        [Passes output test]
    )
)

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[rajendraongole1]

Hi @New_be - Can you check the below measure, i have modified as per data.  replace with your tablename

Passes output test2 =

VAR TotalNormalPass =

    CALCULATE(

        SUM('Totalb'[VALUE]),

        'Totalb'[Actual ST Only] = "TRUE",

        'Totalb'[Num. Re-ST] = "Normal pass"

    )

VAR TotalReST1x =

    CALCULATE(

        SUM('Totalb'[VALUE]),

        'Totalb'[Actual ST Only] = "TRUE",

        'Totalb'[Num. Re-ST] = "Re-ST 1x"

    )

VAR TotalReST2x =

    CALCULATE(

        SUM('Totalb'[VALUE]),

        'Totalb'[Actual ST Only] = "TRUE",

        'Totalb'[Num. Re-ST] = "Re-ST 2x"

    )

VAR AdjustedNormalPass =

    TotalNormalPass

VAR TotalPassesOutput =

    AdjustedNormalPass + TotalReST2x

RETURN

    TotalPassesOutput

Hope this helps.

[New_be]

Hi @rajendraongole1 ,
Thank you for replying.
But yours is correct, mine is not correct:

[rajendraongole1]

Hi @New_be - you can update the measure as shared, you will definitely get the output as expected. 

still any , please upload your pbix file in drive will check.

[New_be]

Hi @rajendraongole1 ,
Thank you for your help. Here is the link  to my sample report -> https://we.tl/t-Fa4wxK6or4