topic Calculate function context issue in DAX Commands and Tips

Calculate function context issue

stieve63 — Thu, 18 Jan 2024 13:49:59 GMT

Hello,

Think I have a context issue with my calculate function:

Tot sales Qty Fietsen =

CALCULATE([Total Sales Quantity],

Products[Product Group Level 1] = "fietsen",

NOT Products[Product Group Level 2] IN {"compensatie afmontage","kortingen"},

Products[Product Group Level 3] <> "accu"

)
See attachment: why is it counting 286 for a lot of lines where I except the same as the Total Sales Quantity (example row 3) or 'blank' (example row 6 'compensatie afmontage') ?

What am I doing wrong in the syntax?

Re: Calculate function context issue

Jihwan_Kim — Thu, 18 Jan 2024 18:23:59 GMT

HI,

I am not sure if I understood your question correctly, but please try something like below whether it suits your requirement.

Tot sales Qty Fietsen = CALCULATE ( [Total Sales Quantity], FILTER ( Products, Products[Product Group Level 1] = "fietsen" && NOT ( Products[Product Group Level 2] IN { "compensatie afmontage", "kortingen" } ) && Products[Product Group Level 3] <> "accu" ) )

Re: Calculate function context issue

stieve63 — Thu, 18 Jan 2024 18:42:17 GMT

Thx a lot Jihwan_Kim
How could I overlook the FILTER function, I feel a bit stupid now but still new at PowerBI, learning everyday 😉