Forum Discussion

stieve63's avatar
stieve63
New Member
2 years ago
Solved

Calculate function context issue

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...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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"
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

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