Problem with summing values based on multiple conditions.

[ArielCz91]

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 · Accepted solution]

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