what's the evalution order of calculate

[Philo_m]

I have defined a measue 

m2 = CALCULATE(

    [Sales Amount],

    'Product'[Category] = "Audio",

    ALL('Product'[Category]),

    KEEPFILTERS('Product'[Category] = "Audio")

)

why there are some null vaues in the matrix

[FreemanZ]

hi @Philo_m 

it seems your measure manipulates only the category column, not color column. So if there is no combination of blue audio, it returns null.