Forum Discussion

Alexbienvenue's avatar
Alexbienvenue
Frequent Visitor
4 years ago
Solved

Incorrect total

Hello everyone, having difficulty solving for a correct total, any and all help appreciated     for context here I need every [SKU] to Display the [juice] in it and display the amount that w...
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Alexbienvenue ;

    Try it.

    test = 
SUMX (
    SUMMARIZE (
        'Wine Processing',
        [Juice],
        [Sku],
        "1",
            CALCULATE (
                SUM ( 'Wine Processing'[Amount] ),
                'Wine Processing'[Action] = "Press",
                ALLEXCEPT ( 'Wine Processing', 'Wine Processing'[Juice] )
            )
    ),
    [1]
)

    Or 

    test 2 = SUMX(
SUMMARIZE('Wine Processing',[Sku],[Juice],"1",

CALCULATE (
    SUM ( 'Wine Processing'[Amount] ),
    FILTER (
        ALL ( 'Wine Processing' ),
        'Wine Processing'[Action] = "Press"
    ),
    VALUES ( 'Wine Processing'[Juice] )
)),[1])

    The final show:

    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Alexbienvenue ;

Try it.

test = 
SUMX (
    SUMMARIZE (
        'Wine Processing',
        [Juice],
        [Sku],
        "1",
            CALCULATE (
                SUM ( 'Wine Processing'[Amount] ),
                'Wine Processing'[Action] = "Press",
                ALLEXCEPT ( 'Wine Processing', 'Wine Processing'[Juice] )
            )
    ),
    [1]
)

Or 

test 2 = SUMX(
SUMMARIZE('Wine Processing',[Sku],[Juice],"1",

CALCULATE (
    SUM ( 'Wine Processing'[Amount] ),
    FILTER (
        ALL ( 'Wine Processing' ),
        'Wine Processing'[Action] = "Press"
    ),
    VALUES ( 'Wine Processing'[Juice] )
)),[1])

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.