Forum Discussion

New_be's avatar
New_be
Helper V
2 years 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...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years 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.

rajendraongole1's avatar
rajendraongole1
Super User
2 years 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.

 

New_be's avatar
New_be
Helper V
2 years ago

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

 

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years 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.