Forum Discussion

ArielCz91's avatar
ArielCz91
Frequent Visitor
3 years ago
Solved

Problem with summing values based on multiple conditions.

Hi, I have a problem obtaining the correct value: I need to obtain the sales sum from the SPR[NETTO] column for the assortment KOLORYZACJA from the table ASORT[poizion2] = "KOLORYZACJA". The sales sum should only include the first month in which the sales for this assortment reached a minimum of 450 for a specific customer[id]. Thank you for your help.

  • baghdadi62's avatar
    baghdadi62
    3 years ago

    Hi,
    If I understand the question correctly, you probably need a formula like this in DAX:

    SalesSum :=
    CALCULATE(
    SUM(ASORT[SPR[NETTO]]),
    ASORT[ASORT[poizion2]] = "KOLORYZACJA",
    ASORT[Sales] >= 450,
    FIRSTDATE(ASORT[Month])
    )

1 Reply

  • baghdadi62's avatar
    baghdadi62
    Resolver III
    3 years ago

    Hi,
    If I understand the question correctly, you probably need a formula like this in DAX:

    SalesSum :=
    CALCULATE(
    SUM(ASORT[SPR[NETTO]]),
    ASORT[ASORT[poizion2]] = "KOLORYZACJA",
    ASORT[Sales] >= 450,
    FIRSTDATE(ASORT[Month])
    )