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 su...
  • 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])
    )

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])
)