Problem with summing values based on multiple conditions.

ArielCz91 — Wed, 19 Jul 2023 10:29:57 GMT

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.

Re: Problem with summing values based on multiple conditions.

baghdadi62 — Wed, 19 Jul 2023 10:55:19 GMT

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

topic Re: Problem with summing values based on multiple conditions. in DAX Commands and Tips

Problem with summing values based on multiple conditions.

Re: Problem with summing values based on multiple conditions.