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.

Anonymous's avatar
Anonymous
Not applicable
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.