Forum Discussion

New_be's avatar
New_be
Helper V
1 year ago
Solved

Wrong total

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:
YearWeekPROCESSMACHINEPRD_ORDERIDActual ST OnlyNum. Re-STGRADINGUNITVALUETotal Normal PassRerun 1xPasses outputPasses output test
Y24W34ST1ST17725354FALSENormal passCSQFT5372.98 1161  
Y24W34ST1ST17725354TRUENormal passC Hitam SapSQFT7225.92722611617225.926065.1
Y24W34ST1ST17725354FALSENormal passC SapSQFT1178.05 1161  
Y24W34ST1ST17725354TRUERe-ST 1xC Hitam SapSQFT1160.82 11611160.821160.82
Y24W34ST1ST17725354TRUERe-ST 2xC Hitam SapSQFT674.91 1161674.91674.91
           9061.659061.65
            7900.83
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

5 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    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.

     

      • rajendraongole1's avatar
        rajendraongole1
        Super User
        1 year ago

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.